Data Lookup

[Dan]

Hello-
I want to populate a table in sheet 1 by matching a cell value to a table
in another worksheet and returning the value related to the cell. Example:

Sheet1
Value 1 Value 2
B return value of 41 from WS 2 if matches with "B" in value 1
A return value of 39 from WS 2 if mathes with "A" in value 1
C return value of 42 from WS 2 if matches with "C" in value 1

Sheet 2
Value 1 Value 2
A 39
B 41
C 42

Thanks for your help.

 

[Bob Phillips]

Look at VLOOKUP in help.

 

[microsoft.public.excel.worksheet.functio]

Hi Dan. Let me know if you still need the help. Best regards.
Argy