Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to Find Matching Data
I'm thinking a lookup type function would work for what I need, but I'm not
too familiar with that function, and what I tried didn't work. Any help would be appreciated. I have values in column C that Id like to find in column B, then copy the data from column A in that corresponding row, and update column D with the data from column A. To clarify. . . For example: In row one I have €˜123 in column C. I want to find €˜123 in column B -- say its found in row two -- then copy the data from column A in row two and paste it into column D in row one, where the formula originated. Can this be accomplished? Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to Find Matching Data
=INDEX(A2:A100,MATCH(C1,B2:B100,0))
adapt to fit to your own cell references -- Regards, Peo Sjoblom "NM" wrote in message ... I'm thinking a lookup type function would work for what I need, but I'm not too familiar with that function, and what I tried didn't work. Any help would be appreciated. I have values in column C that I'd like to find in column B, then copy the data from column A in that corresponding row, and update column D with the data from column A. To clarify. . . For example: In row one I have '123' in column C. I want to find '123' in column B -- say it's found in row two -- then copy the data from column A in row two and paste it into column D in row one, where the formula originated. Can this be accomplished? Thank you. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to Find Matching Data
Ah, INDEX. No wonder lookup commands didn't work. :-p
This worked perfectly. Thank you for your time and assistance. "Peo Sjoblom" wrote: =INDEX(A2:A100,MATCH(C1,B2:B100,0)) adapt to fit to your own cell references -- Regards, Peo Sjoblom "NM" wrote in message ... I'm thinking a lookup type function would work for what I need, but I'm not too familiar with that function, and what I tried didn't work. Any help would be appreciated. I have values in column C that I'd like to find in column B, then copy the data from column A in that corresponding row, and update column D with the data from column A. To clarify. . . For example: In row one I have '123' in column C. I want to find '123' in column B -- say it's found in row two -- then copy the data from column A in row two and paste it into column D in row one, where the formula originated. Can this be accomplished? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find matching data in two worksheet columns | Excel Worksheet Functions | |||
Find Matching Data Two Columns | Excel Worksheet Functions | |||
How do I compare data in two worksheets to find matching cells? | Excel Discussion (Misc queries) | |||
compare data in two lists to find matching entries | Excel Discussion (Misc queries) | |||
compare data in two lists to find matching entries | Excel Discussion (Misc queries) |