Vlookup Week

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 Office2010-Blog.de, 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=http://www.youtube.com/watch?v=BntEZ1szusI]

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: https://people.highline.edu/mgirvin/ExcelIsFun.htm [youtube=http://www.youtube.com/watch?v=u-8D2G0y9EM]

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


Beginner to Advanced uses of The Lookup Function

“VLOOKUP, OFFSET and MATCH in PowerPivot” from Javier Guillén


“In Excel, we can use a formula like the one below to generate this ‘double lookup’ calculation…”

Learn Excel from MrExcel