Look at VLOOKUP in help.

--
__________________________________
HTH

Bob

"Dan" wrote in message
...
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.