MSExcel

“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…”

Que Publishing: “Video Podcasts on VLOOKUP Formulas “

               

VLOOKUP Formulas Featuring Bill Jelen!

From The MS Office Blog: “VLOOKUP Tutorial: Updating prices in a master product list”

               

From Emily Warn at Microsoft Excel Blog: “In honor of VLOOKUP Week, MVP Bill Jelen has created a VLOOKUP tutorial for those of you who have a basic working knowledge of Excel but want to improve your skills. You most likely know the core set of formulas that come with Excel and have heard that VLOOKUP is(…)

Colin Legg and “Binary Searches With VLOOKUP”

               

Why would anyone ever pass TRUE into VLOOKUP’s range_lookup parameter?

Neil Malek “Fun with VLOOKUP”

               

MATCH, Data Validation and More!

Learn Excel from MrExcel