| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Lookup returns #NA when search value (text) has leading zeros.
I'm working with inventory where drawing numbers have leading zeros. I need
to lookup the drawing number from a different sheet and return the correct part number. The lookup function is returning #N/A for all of the drawing numbers that have leading zeros, the rest work just fine. The search values are text type on both sheets. The return value is a general type (integer). How can I get this to work? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search a Column by text length | Excel Worksheet Functions | |||
| How do I search for text within text? | Excel Discussion (Misc queries) | |||
| How do I get carriage returns to not be row delimiters in text fi. | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Threaded Mode
