The_Rock
Board Regular
- Joined
- Jul 2, 2007
- Messages
- 174
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!
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!