Charles Williams

Dueling Excel – “Get Averages for a Set of Numbers”: Podcast #1657

               

Mike and Bill Solve a not-so AVERAGE Question…

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(…)

Learn Excel from MrExcel