Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I know this is easy, but I'm having a complete brain-fart on how to do
it. I've got a column of values on one sheet, and I want to match each individual value in that column with the same value on another sheet, then return the value in that same row. Simplified example: Column A Column B Column C Column D a a 1 1 a b 2 1 d c 3 4 e d 4 5 c e 5 3 b f 6 2 c g 7 3 c h 8 3 So I've got values in Column A which I'm trying to match to a list of values in Column B. When it matches, I want it to look up the corresponding value (same row) in Column C, returning that value in Column D (the above table is filled out as to how it should look when done). I think I can do this with some combination of LOOKUP, MATCH, and INDEX, but I can't seem to get the syntax correct. TIA!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
To copy values in a column relevant to text in an adjacent column? | Excel Worksheet Functions | |||
How to get the values using a condition refering to the other column | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
lookup from one column return value from another? | Excel Discussion (Misc queries) | |||
Lookup then Match and insert value from next column | Excel Worksheet Functions |