Right now I am using the VLookup below to let me know if the code in C6413 is Valid or Not by comparing it to another tab. If C6413 is listed on the Codes Tab there is a match and the word Valid will appear in cell B6413.
=VLOOKUP(C6413,Codes!B:E,4,FALSE)
However, if cell B6413 is blank you get an error (#N/A) message in cell C6413.
1 I am trying to avoid the error message.
2 If the code in cell B6413 does not appear on the codes tab I would Like the word INVALID to appear in cell C6413
I tried the formula below but it doesn't work and I am lost. Any suggestions???
=IF(ISERROR,0(VLOOKUP(C6413,Codes!B:E,4,FALSE))
Bookmarks