When I announced VLOOKUP Week, Charley Kyd was one of the first to respond with something along the lines of “I never use VLOOKUP and I will be happy to tell you why!” Although Charley was one of the first to respond, I figured I should hold this post for a few days so I did not burst the bubble of anyone new to VLOOKUP. To read why Charley likes INDEX/MATCH better than VLOOKUP, check out his complete post.
Tag Archives: Charley Kyd
By Bill Jelen
Excel Lookup Function
Function by NameAdvanced VLookup Array Atlas Programming Management Inc bad data Basic Bill Jelen Bruce Mcpherson BUSCAR busca un valor en un vector Case CHOOSE Colin Legg Crystal Long Dan Bricklin Data Validation David Parrott DAX Debra Dalgleish door prize Entusiasta del Excel EXACT Excel Excel-User Excel-User.com Excel 2010 ExcelisFun FLOOR HLookup How To Set Up A VLookup in Excel INDEX INDIRECT Ivana Taylor James Chen Javier Guillén JP Pinto JPPinto Left Linked In LOOKUP Lookup Function love note MATCH Microsoft Blog Microsoft Excel Microsoft MVP Microsoft Office Blog Mike Girvin MrExcel MS Access MSExcel MS Excel MSMVP necesitomas.com ode Paco Megía Morales Patsy Cline Pearson Publishing Plunk PowerPivot QUE Publishing RELATED Richard Schollar Rob Collie Search a value in a vector Software TEXT Tom Urtis VisiCalc Visual Basic VLookup VLOOKUP and PowerPivot VLookup Formula VLookup Formulae VLookup in Excel Vlookup Week XLCalibre