floggingmolly
Board Regular
- Joined
- Sep 14, 2019
- Messages
- 167
- Office Version
- 365
- Platform
- Windows
I have the formula below which works. It looks in column 11 and if blank it uses the value in column 12. If the value in H2 isn't in my table array, how can I hide the #N/A error? Any help would be greatly appreciated.
=IF(VLOOKUP(H2,BDS_Alignment,11,FALSE)="",VLOOKUP(H2,BDS_Alignment,12,FALSE),VLOOKUP(H2,BDS_Alignment,11,FALSE))
=IF(VLOOKUP(H2,BDS_Alignment,11,FALSE)="",VLOOKUP(H2,BDS_Alignment,12,FALSE),VLOOKUP(H2,BDS_Alignment,11,FALSE))