MrExcel Excel Videos

VLOOKUP WEEK is moving along and Bill brings us another use of VLOOKUP combined with the 'Consolidate Function'. Also, Save The Date: March 29th, 2012 beginning at 2PM EDT! Bill will be presenting a VLOOKUP Webcast on CFO.com! Be sure to register for this event! For more information, go to http://www.cfo.com/webcasts/index.cfm/l_eventdetail?webcast=14620943 Welcome toVLOOKUP WEEK 2012! What is VLOOKUP WEEK, you ask? VLOOKUP WEEK is an entire week [March 25th, 2012 through March 31st, 2012] dedicated to one of the greatest yet least used Functions of Microsoft Excel. Check out the VLOOKUP WEEK 2012 Blog! So many folks have already contributed and continue to contribute -- with new entries flowing through the Inbox every hour or...

Using VLookup, Bill selects two winners!

In the spirit of "VLOOKUP WEEK 2012" [march 25th - March 31st, 2012], Bill centers on VLookup again today. In theory, I sent my workbook to my manager. I have received the workbook back from my manager and now I need compare the data [the original data with the new data] to find out what was deleted, what was added and what was changed. Today Bill shows us how to work with VLOOKUP to find the answers to our questions. Welcome toVLOOKUP WEEK 2012! What is VLOOKUP WEEK, you ask? VLOOKUP WEEK is an entire week [March 25th, 2012 through March 31st, 2012] dedicated to one of the greatest yet least used Functions of Microsoft Excel. Check out the VLOOKUP WEEK 2012 Blog!

The Door Prize Winners for 26-March-2012 -during the week-long 'VLOOKUP WEEK 2012' get together - were Jerri Lowrimore and Lukasz Czekaj... but how were they chosen? With Excel, of course. Watch the video to see how Bill set up the VLOOKUP and RANDBETWEEN combo to produce the results!

Bill starts from the beginning; why to use a VLOOKUP, when to use a VLOOKUP and how to Use a VLOOKUP. If you are ready to unravel the mystery of VLOOKUP, follow along with Episode #1533 as Bill Starts off VLOOKUP WEEK 2012 with a comprehensive how-to. Welcome toVLOOKUP WEEK 2012! What is VLOOKUP WEEK, you ask? VLOOKUP WEEK is an entire week [March 25th, 2012 through March 31st, 2012] dedicated to one of the greatest yet least used Functions of Microsoft Excel.

Bill's advise for any avid Kayaking Excel Beginner, Enthusiast or Guru.

Well, we know it's not rocket science...

VLookup Week Promo