I have the following formula:
=IF(VLOOKUP(B3,BARCODES!C:D,1,FALSE)=B3,"ISSUED!!","Free")
which checks down a list of barcodes to confirm whether each number has been issued or not.
This works, but when the 'value-is-false' I get a #N/A value rather than the "free" value as indicated in my formula.
Is there a way to get the correct value?
=IF(VLOOKUP(B3,BARCODES!C:D,1,FALSE)=B3,"ISSUED!!","Free")
which checks down a list of barcodes to confirm whether each number has been issued or not.
This works, but when the 'value-is-false' I get a #N/A value rather than the "free" value as indicated in my formula.
Is there a way to get the correct value?