ISNA VLOOKUP any data prefixed with a "C7" cannot be found?

M

Mike Jenkins

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!:confused:
 
V

Vito

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?
 
P

Pete

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
 
M

Mike Jenkins

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?:)
 
M

Mike Jenkins

Range is all inclusive.

Just seems to miss random product codes.
:confused:


See lookup formula in above reply....
 
P

Pete

Maybe you have spaces at the end of a few codes in the lookup table -
use TRIM() to get rid of these.

Pete
 
R

rsenn

In addition to the TRIM function, you may want to used the CLEAN
function on the data table being imported from the other application.
 
Top