Nested IF(ISERROR statement

Hi,

I am looking to write a nested IF statement so that if the first index(match returns #N/A then it does the second statementand then finally the third one.

After researching this I think I need to include the ISERROR function but I can't figure it out.

Here is the 3 index(match function prioritized 1-3:

1. INDEX('Globals SFDC'!B:B,MATCH('12-29 Mapping'!B2,'Globals SFDC'!A:A,0))
2. INDEX(GAM!H:H,MATCH('12-29 Mapping'!A2,GAM!F:F,0))
3. INDEX('All TRX Swen'!O:O,MATCH('12-29 Mapping'!C2,'All TRX Swen'!N:N,0))

Thank you very much for your help.

Jasper

This worked flawlessly, thank you very much.