Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup data based on data comparison | Excel Worksheet Functions | |||
lookup data | Excel Worksheet Functions | |||
how do I lookup data based on two columns of data | Excel Worksheet Functions | |||
Another way to lookup data | Excel Worksheet Functions | |||
The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) |