Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting a lookup
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(A200, LOOKUP(C20,UPC!H:H,UPC!B:B),"") |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting a lookup
Try
=IF(A200, INDEX(UPC!B:B,MATCH(C20,UPC!H:H,0),"") -- Regards, Peo Sjoblom "Heather C" wrote in message ... 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(A200, LOOKUP(C20,UPC!H:H,UPC!B:B),"") |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting a lookup
That doens't work
"Peo Sjoblom" wrote: Try =IF(A200, INDEX(UPC!B:B,MATCH(C20,UPC!H:H,0),"") -- Regards, Peo Sjoblom "Heather C" wrote in message ... 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(A200, LOOKUP(C20,UPC!H:H,UPC!B:B),"") |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting a lookup
On Apr 25, 9:49*am, Heather C
wrote: 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(A200, LOOKUP(C20,UPC!H:H,UPC!B:B),"") Try =IF(A200,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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting a lookup
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 "Heather C" wrote in message ... That doens't work "Peo Sjoblom" wrote: Try =IF(A200, INDEX(UPC!B:B,MATCH(C20,UPC!H:H,0),"") -- Regards, Peo Sjoblom "Heather C" wrote in message ... 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(A200, LOOKUP(C20,UPC!H:H,UPC!B:B),"") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting using lookup | Excel Discussion (Misc queries) | |||
lookup function formatting | Excel Discussion (Misc queries) | |||
Keep formatting with lookup table | Excel Discussion (Misc queries) | |||
lookup certain formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting - Lookup Range | Excel Discussion (Misc queries) |