Vloohp & Index

[The_Rock]

Hi Folks
The following formula first looks in one table, if it doesn't find it in there, it looks in another table.
If its not in either it returns #N/A

=IFERROR(VLOOKUP(AZ2,'Failure Reason'!AC:AD,2,FALSE),INDEX('Failure Reason'!B:B,MATCH('SIP YTD'!AZ3,'Failure Reason'!D:D,0)))


Would appreciate your idea's on how to modify the formula so that #N/A appears as "-".

Thanks!

 

[Andrew Poulsom]

Like this?

=IFERROR(VLOOKUP(AZ2,'Failure Reason'!AC:AD,2,FALSE),IFERROR(INDEX('Failure Reason'!B:B,MATCH('SIP YTD'!AZ3,'Failure Reason'!D:D,0)),"-"))

 

[The_Rock]

Absolutely Perfect - Thank You