H
Heather C
I have an invoice set up so I can scan a UPC and it pulls the item number,
however some of the items have the wrong bar code in the system. I would
like to set it up so that if the UPC doesn't match exactly it doesn't pull
anything up, right now it pulls up the closest item number. The formula I'm
using is: =IF(A20>0, LOOKUP(C20,UPC!H:H,UPC!B:B),"")
however some of the items have the wrong bar code in the system. I would
like to set it up so that if the UPC doesn't match exactly it doesn't pull
anything up, right now it pulls up the closest item number. The formula I'm
using is: =IF(A20>0, LOOKUP(C20,UPC!H:H,UPC!B:B),"")