MSExcel

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 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

Learn Excel from MrExcel