Multiple Match Excel

Question

My goal is to Match the Primary Key's of two different sheets in Excel. In this scenario, the primary key has multiple duplicates, but is differentiated with column TYPE.

What would be the way for me to Match the Primary Key to the correct key with only TYPE = 'A'?

=INDEX('SHEET 1'!C:C,MATCH(A2,'SHEET 1'!A:A)) This code is matching the primary key to both sheets to obtain name, however I do not know how to specify/match the TYPE = 'A' as well>

Image 1 with the code

Image 2Reference Data

Those pictures are Google-Sheets not excel. They are not the same and things that work in one may not work in the other. Which are you using? — Scott Craner, Jul 19 '22 at 18:49

score 0 · Answer 1 · answered Jul 19 '22 at 19:36

0

Make a helper column in sheet1 with formula =A2&B2 It will give "x1A" "X1B"....

then use this formula: =INDEX(Sheet1!C:C,MATCH(A2&"A",Sheet1!E:E,0))

observe there is a Zero in the end of the Match function.

If someone knows how to do this without helper column, I would be thankful to see that solution.

answered Jul 19 '22 at 19:36

WeAreOne

1,310
1
2
13

1

https://stackoverflow.com/questions/42492758/vlookup-using-2-columns-to-reference-another/42493697#42493697 – Scott Craner Jul 19 '22 at 19:40

Multiple Match Excel

1 Answers1