Collection of VLOOKUP Week Articles

March 25, 2012 - by Bill Jelen

Back in 2012, I asked many of my Excel friends to write an article for VLOOKUP week. Many of these are still live on the web.

• » VLOOKUP Week Designed to Educate, Entice, and Illuminate Excellers
• » Tom Urtis Explains HLOOKUP
• » CFO.com article: Handle Growing Lookup Tables with a Two-Key Combo
• » Tom Urtis: Case-Sensitive VLOOKUP
• » Rob Collie from PowerPivotPro: Does PowerPivot make VLOOKUP Obsolete?
• » James Chen: Use Consistent Sheet Names
• » Richard Schollar: VLOOKUP Left!
• » I Would be Screwed at my Job without VLOOKUP! (Ode to VLOOKUP)
• » Debra Dalgleish Uses VLOOKUP to Track Shark Attacks
• » David Parrott Explains "Getting Started with VLookup"
• » Búsquedas y referencias [Searches and References] from Necesitomas.com
• » JP Pinto: "Get A Value Based on Another Value"
• » Bruce Mcpherson - INDEX and MATCH on Large Data Sets
• » JP Pinto: "Cascading Validation Lists w/ VLookup"
• » Jorge Paulino "Excel: Dicas de VBA - vLookupValues() uma Variante do Vlookup()"
• » Charley Kyd from ExcelUser.com never uses VLOOKUP
• » Javier Guillén "Simulates an "approximate match" VLOOKUP in PowerPivot"
• » From Somkiat Foongkiat: "สูตร VLookup" [VLookup Formula]
• » Colin Legg looks at "Why Does VLOOKUP Return An #N/A Error?"
• » Colin Legg and "Binary Searches With VLOOKUP"
• » "VLOOKUP, OFFSET and MATCH in PowerPivot" from Javier Guillén
• » Rahim Zulfiqar Ali: "Getting Started with New Ideas on LOOKUP"
• » Tom Urtis: Lookup with 2 or more criteria
• » Ute Simon: "Currency Conversion Excel 2010 with VLOOKUP & Conditional Formatting"
• » Charles Williams: "Why 2 VLOOKUPS are better than 1 VLOOKUP"
• » From 'The Data Specialist': "A look at the VLOOKUP function"
• » Tom Urtis: "Reverse Intersecting Lookup: Return Row and Header Labels"
• » Tom Urtis: "Lookup First and Last Values Along Row"
• » Charles Williams: Doing a wildcard vlookup!
• » Looking Up Multiple Criteria with INDEX and SUMPRODUCT