If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filtering data in three columns based on the content of two other columns
Hey all,
Basically, I have a last, first, and initial in column A, B, C respectively - a list of 1000. Then I have last, first in column D, E respectively - a list of 200. The idea is to get the first and last name that match between A/B and D/E into their own column. So in Column F, I use this: Code:
=D1&" "&E1 Then in Column G, I use this: Code:
=A1&" "&B1 Now I want to compare column F and G and whichever first and last names match, then I want the matching first name, last name, and middle initial of column A, B, C to be in their own new columns. So in column H, I do this: Code:
=INDEX($A$1:$C$1000,MATCH($F1:$F200:$G1:$G1000,0)) Thanks for any response. |
Thread Tools | |
Display Modes | |
|
|