Using index match based on two match criteria in different columns

[LearningByError]

Hi everyone. I'm trying to use index match based on two criteria but aren't entirely sure how to go about it.

I have a spread sheet that has multiple different sizes with the same name. What I am looking for is something that will search for the name/value in column A then search for the second value in column B and if it doesn't match both values continue looking through the spreadsheet until it finds the correct row. Then use the index function to return the value in column 3 of that row. Example attached

In the example I am looking for the values in E5 and F5 in column A and B respectively. If found it should return the value in G5.

Any help is appreciated.

Thanks,
LearningByError.

[LearningByError]

I've actually just figured this out, it was much easier than expected. I used the formula below on my sheet.

=IF(MATCH(F4,Sheet4!$A$2:$A$552,0),INDEX(Sheet4!$E$2:$E$552,MATCH(G4,Sheet4!$I$2:$I$552,0)),"").

I looked for a match based on the name first or value (F4), and If there was a Match, To match a second value (G4), and then Index to return the value on the same row of both the match in Column E. I'm honestly confused myself on how this works out and isn't returning occasional errors.

If anyone has a better way I'm game to see it.

Thanks,
LearningByError.

[Czeslaw]

I propose such formulas

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.