I have 2 columns worth of data (ie: B and C). I want to see if there are matches AND if there are matches, I want another column's data to be shown (ie: A).
Columns B and C are peoples names and column A are employee numbers. Sat around bouncing ideas off coworkers and we could not figure anything out.
Not real clear.
Post a few rows worth of data and tell us what result you expect.
Also, tell us what version of Excel you're using.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
A | B C D
NAME | NAME Employee ID
John Smith | John Doe 3445
Jessica Lane | Mike Hill 9920
John Doe | Jane Doe 9803
I am attempting to find matches between "A" and "B", and if there is a match, I want the Employee ID to be shown in "D". Also, I am running Office 2010.
It might be better if you post a sample file that includes the results you expect.
~20 rows worth of data will be plenty.
HELP.png
Hope this makes its a little more clear- After looking at it for so long, I have begun to confuse myself
Hi,
a small attempt
Hope it helps
=INDEX(D2:D100,MATCH(1,INDEX((A2:A100="Pam")*(C2:C100="Jerry"),),0))
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
TPDave: Yes, that would be the ultimate goal
So in column F you want every entry in column D that appears alongside a match in names from columns A and C?
That is along the line of what I need, but "Pam" and "Jerry" are not matches [the blue column is trying to represent the two being seperate columns]. I would like to see the name "Seth" match and produce his ID "2567" in Column F
^But in your example "Seth" isn't a matching line? As Tony Valko said it would be very helpful if you could upload a file that contains a few rows of data with your expected results for us to work with.
Thanks
test.xlsx
Is this good enough?
Try this...
Data Range
This array formula** entered in F2:
=IFERROR(INDEX(D:D,SMALL(IF(ISNUMBER(MATCH(C$2:C$11,A$2:A$11,0)),ROW(D$2:D$11)),ROWS(F$2:F2))),"")
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Copy down until you get blanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks