Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP Woes
Greetings all. I know the answer is here, but I can not get this to work.
On sheet 1 I have col A "ID" and col B "Name" which are data input columns. On sheet 2 I have col A "ID" and col B "Name" which is the name of the person corresponding to the ID on the same row in col A, and is to be used as my lookup table. The values on sheet 2 are contained in the range A1:B15. What I want is for the persons name to autopopulate on sheet 1 col B when I input the ID in col A. I am confused by the syntax of VLOOKUP. Thank you for the help. Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More RGB Woes | Excel Programming | |||
HELP: Dir() time-out woes :( ..... | New Users to Excel | |||
Userform Woes | Excel Programming | |||
Comma Woes | Excel Worksheet Functions | |||
For Each Next woes | Excel Programming |