Charles Williams: “Why 2 VLOOKUPS are better than 1 VLOOKUP”


Microsoft Exel MVP Charles Williams sends in his contribution to VLOOKUP WEEK. For all you VLOOKUP junkies who can’t get enough of VLOOKUP, here is a wonderful reason to use 2 VLOOKUPs instead of 1 !! Exact Match VLOOKUP is slow When you have a lot of data in Excel (think 10,000 or 100,000 or(…)

Ute Simon: “Currency Conversion Excel 2010 with VLOOKUP & Conditional Formatting”


Submitted to the VLOOKUP WEEK 2012 Blog, by Ute Simon (Microsoft PowerPoint MVP, Germany) at, is a German Language entry posted at the Office2010-Blog by Frank Arend-Theilen (Former Excel-MVP). This entry is a Currency Conversion Worksheet created in Excel 2010. “Sommerzeit ist Reisezeit! Die Koffer sind schon gepackt. Da die Fahrt auch in Länder führt, die nicht(…)

Bill Jelen: “Consolidate and Lookup”


VLOOKUP WEEK is moving along and Bill brings us another use of VLOOKUP combined with the ‘Consolidate Function’. [youtube=]

Mike ‘ExcelisFun’ Girvin: “INDEX and MATCH How-To”


Mike ‘ExcelisFun’ Girivn checks in for day 3 of VLOOKUP WEEK 2012 with “INDEX and MATCH How To”. There are approximately 30 examples in this 1 hour ‘+’ video! Example Files are available – Download files: [youtube=]

Rahim Zulfiqar Ali: “Getting Started with New Ideas on LOOKUP”


Beginner to Advanced uses of The Lookup Function

Learn Excel from MrExcel