Why isn't that INDEX and MATCH returing #NA

[Sean15]

Hello:

This formula is return #NA.

Look up value in AY2 and E2 are sheet #2

INDEX(Sheet1!$A$2:$A$2201,MATCH(AY2,Sheet1!$B$2:$B$2201,0),MATCH(E2,Sheet1!$B$2:$C$2201,0))

Could you help please.


Regards,

Sean

 

[AhoyNC]

You could try this:
=IFERROR(INDEX(Sheet1!$A$2:$A$2201,IFERROR(MATCH(E8,Sheet1!$B$2:$B$2201,0),MATCH(AY8,Sheet1!$B$2:$B$2201,0))),"Not Found")

Its going to look for a match of E8 in column B, if not found it will look to see if there is a match of AY8 in column B. If nether returns a match then it should return the "Not Found". Is that what you are trying to do?

 

[Sean15]

@AhoyNC

Your formula returns the required results. Thank you very much.


Regards,

Sean

 

[AhoyNC]

You're welcome. Thanks for the feedback.