listi.net

Listi.net

             


When VLookup goes wrong

VLookup is a Microsoft Excel function that allows you to convert 1 value to another by looking it up. An example is if you had the numbers of a bunch of baseball players and wanted to include their names.

On Sheet2 you have the following:

 AB
1NumberName
21Bill Martin
32Derek Jeter
43Babe Ruth
54Lou Gehrig
65Joe DiMaggio
77Mickey Mantle
88Yogi Berra
915Thurman Munson


To include the VLookup code the following:

=VLookup(2,Sheet2!A:B,2,False)