| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ISNA VLOOKUP any data prefixed with a "C7" cannot be found?
Currently working on a quotation workbook, whereby monthly data dumps result in users being able to create a quote by cutting in product codes. Major problem is that any time a product code that is prefixed with "C7" is entered the product description is NOT pulled through onto the quotation form. Any suggestions on how to fix this would be much appreciated!  -- Mike Jenkins ------------------------------------------------------------------------ Mike Jenkins's Profile: http://www.excelforum.com/member.php...o&userid=29588 View this thread: http://www.excelforum.com/showthread...hreadid=492880 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ISNA VLOOKUP any data prefixed with a "C7" cannot be found?
Is C7 just a prefix to a code (e.g C7ABC)? What does your Vlookup look like now? Do you only want to lookup the part after the C7? -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=492880 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ISNA VLOOKUP any data prefixed with a "C7" cannot be found?
It might be that the range in your lookup formula doesn't cover all the
data if you have added new items to the product codes. Pete |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ISNA VLOOKUP any data prefixed with a "C7" cannot be found?
Is C7 just a prefix to a code (e.g C7ABC)? YES "C7200-I/O-2FE/E" What does your Vlookup look like now? " =IF(ISNA(VLOOKUP('Quote Calculator'!A4,'Price List'!$C$13:$D$28262,2)),"",VLOOKUP('Quote Calculator'!A4,'Price List'!$C$13:$D$28262,2))" Do you only want to lookup the part after the C7? - no I require to lookup the entire product code. Any suggestions?:) -- Mike Jenkins ------------------------------------------------------------------------ Mike Jenkins's Profile: http://www.excelforum.com/member.php...o&userid=29588 View this thread: http://www.excelforum.com/showthread...hreadid=492880 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ISNA VLOOKUP any data prefixed with a "C7" cannot be found?
Range is all inclusive. Just seems to miss random product codes. See lookup formula in above reply.... -- Mike Jenkins ------------------------------------------------------------------------ Mike Jenkins's Profile: http://www.excelforum.com/member.php...o&userid=29588 View this thread: http://www.excelforum.com/showthread...hreadid=492880 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ISNA VLOOKUP any data prefixed with a "C7" cannot be found?
Maybe you have spaces at the end of a few codes in the lookup table -
use TRIM() to get rid of these. Pete |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ISNA VLOOKUP any data prefixed with a "C7" cannot be found?
In addition to the TRIM function, you may want to used the CLEAN function on the data table being imported from the other application. -- rsenn ------------------------------------------------------------------------ rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050 View this thread: http://www.excelforum.com/showthread...hreadid=492880 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data validation using vlookup | Excel Worksheet Functions | |||
| Vlookup for data contained in a cell | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Using VLOOKUP to draw data from two columns | Excel Discussion (Misc queries) | |||
| Data Source Name Not Found | Excel Worksheet Functions | |||
Linear Mode
