Thread: Data Lookup
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
microsoft.public.excel.worksheet.functio[_2_] microsoft.public.excel.worksheet.functio[_2_] is offline
external usenet poster
 
Posts: 19
Default Data Lookup

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

"Dan" wrote:

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.