vlookup - Nested If statement Excel - checking if value exists - Stack ...

Just replace "" in the Value_if_true part of your formula with "NA" . =IF(ISNA( VLOOKUP(Q3,'Libary Books 21-06-13'!$A:$B,2,FALSE)),"NA" ...

www.google.com.tw