Multiple IFERROR in IndexMatch Formula ?

[trinston]

Hello,

I am exporting a bunch of asset data from our property accountability system and it is very messy, multiple location fields that are manually entered with no requirements. I am using this data to try to narrow these locations down to a city, state, and building number so we can clean up the data in the system. There are 3 fields that I am trying to use an indexmatch on. Column D, UIC, is the primary field for location that I want to match, but if that returns no information/#N/A from our table then I built the function to move on to Column B, Sub Loc and match from that using an IFERROR statement. I was trying to use another IFERROR to get it to move on to the final column from there, so if nothing returns in the match from Column D, and then B, to move on to Column A, but I keep getting errors. Would anyone mind assisting? I feel like this is an easy fix but I just can't get it. Here is my formula, basically want to add on another match to this.

Current Formula:
=INDEX(DataArray!B:B,IFERROR(MATCH(D:D,DataArray!A:A,0),MATCH(B:B,DataArray!A:A,0)))

Would like it to add 1 more match if an error is detected upon the 2nd match:
=INDEX(DataArray!B:B,IFERROR(MATCH(D:D,DataArray!A:A,0),MATCH(B:B,DataArray!A:A,0),MATCH(AA,DataArray!A:A,0)))

Thank you!

[Jonmo1]

Try

=INDEX(DataArray!B:B,IFERROR(MATCH(D:D,DataArray!A:A,0),IFERROR(MATCH(B:B,DataArray!A:A,0),MATCH(AA,DataArray!A:A,0))))

[trinston]

Worked perfectly, I must have tried every variation except for that one for some reason. Thank you!

[Jonmo1]

You're welcome