Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare EE #s & Copy Info
I'm for a formula that will compare 2 columns and copy an adjacent column if
they match. In the example below, I would compare the EE#s in columns B and c and if they match, it would copy the name in column A to column D. A B C D Name EE# EE# Desired Result Tom 24 11 Tony Bill 36 24 Tom Tony 11 36 Bill |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare EE #s & Copy Info
Try this in D2:
=INDEX($A$2:$A$50,MATCH(C2,$B$2:$B$50,0)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steve C" wrote in message ... I'm for a formula that will compare 2 columns and copy an adjacent column if they match. In the example below, I would compare the EE#s in columns B and c and if they match, it would copy the name in column A to column D. A B C D Name EE# EE# Desired Result Tom 24 11 Tony Bill 36 24 Tom Tony 11 36 Bill |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare EE #s & Copy Info
Perfect. Thanks.
"RagDyer" wrote: Try this in D2: =INDEX($A$2:$A$50,MATCH(C2,$B$2:$B$50,0)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steve C" wrote in message ... I'm for a formula that will compare 2 columns and copy an adjacent column if they match. In the example below, I would compare the EE#s in columns B and c and if they match, it would copy the name in column A to column D. A B C D Name EE# EE# Desired Result Tom 24 11 Tony Bill 36 24 Tom Tony 11 36 Bill |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare EE #s & Copy Info
You're welcome, and thanks for the feed-back.
-- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Steve C" wrote in message ... Perfect. Thanks. "RagDyer" wrote: Try this in D2: =INDEX($A$2:$A$50,MATCH(C2,$B$2:$B$50,0)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steve C" wrote in message ... I'm for a formula that will compare 2 columns and copy an adjacent column if they match. In the example below, I would compare the EE#s in columns B and c and if they match, it would copy the name in column A to column D. A B C D Name EE# EE# Desired Result Tom 24 11 Tony Bill 36 24 Tom Tony 11 36 Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare and group like numbers and info | Excel Worksheet Functions | |||
How do I compare info in on sheet to info in another? | Excel Discussion (Misc queries) | |||
Compare 2 Sheets and Extract Unique Info to a 3rd Sheet | Excel Discussion (Misc queries) | |||
compare info in 4 worksheets and highlight fields that are the sam | Excel Worksheet Functions | |||
compare columns of info | Excel Discussion (Misc queries) |