formatting a lookup

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),"")
 
J

jlclyde

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 formulaI'm
using is: =IF(A20>0, LOOKUP(C20,UPC!H:H,UPC!B:B),"")
Click to expand...

Try =IF(A20>0,IF(ISERROR(LOOKUP(C20,UPC!
B:B,FALSE))=TRUE,"",LOOKUP(C20,UPC!B:B,FALSE),"")) If you enter FALSE
it has to find an exact match. Then by adding an error checker llike
ISERROR will tell the formula if it found an exact match or not. I am
not sure if all parenthasis are in the right spot but this shoudl get
you close.

Jay
 
P

Peo Sjoblom

Be more specific when people are trying to help you, what does not work. It
would find an exact match so if there
is no match it will show #N/A.


--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting a lookup 5
Trying to do a Lookup 5
Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
VLOOKUP and highlight row 6
Excel applications for a Barcode scanner 3
Show formatting marks 1
relation question 5
copy paste but not keying in works 1

Top