I have an invoice set up where it looks up the item number off of the upc,
however some of the upc's on the products don't match the ones in the
computer. Right now excell brings up the closest match to the upc. I would
like it if thier was a way that it would bring up nothing or an error if the
upc doesn't match exactally. The formula i'm using is:
=IF(A200, LOOKUP(C20,UPC!H:H,UPC!B:B),"")