| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting a lookup
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),"") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formatting a lookup | Excel Discussion (Misc queries) | |||
| 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) | |||
![Heather C[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
