Thread: VLOOKUP Woes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Snidow Greg Snidow is offline
external usenet poster
 
Posts: 153
Default 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