The_Rock
Board Regular
- Joined
- Jul 2, 2007
- Messages
- 174
Hi Folks
I would appreciate your help with the following.
I am using IFERROR to look up two different tables. If it cannot find it in any table, it returns #N/A
I want to turn that #N/A to "-"
This is the formula:
=IFERROR(VLOOKUP(F12,'Non WE Oppties to include'!B:C,2,FALSE),VLOOKUP(A12,'Non WE Oppties to include'!G:H,2,FALSE))
Cheers
I would appreciate your help with the following.
I am using IFERROR to look up two different tables. If it cannot find it in any table, it returns #N/A
I want to turn that #N/A to "-"
This is the formula:
=IFERROR(VLOOKUP(F12,'Non WE Oppties to include'!B:C,2,FALSE),VLOOKUP(A12,'Non WE Oppties to include'!G:H,2,FALSE))
Cheers