software

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
quot;C7quot; 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: www.excelforum.com/member.php...oamp;userid=29588
View this thread: www.excelforum.com/showthread...hreadid=492880
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: www.excelforum.com/member.php...oamp;userid=29182
View this thread: www.excelforum.com/showthread...hreadid=492880It 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
Is C7 just a prefix to a code (e.g C7ABC)?

YES quot;C7200-I/O-2FE/Equot;What does your Vlookup look like now? quot;

=IF(ISNA(VLOOKUP('Quote Calculator'!A4,'Price
List'!$C$13:$D$28262,2)),quot;quot;,VLOOKUP('Quote Calculator'!A4,'Price
List'!$C$13:$D$28262,2))quot;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: www.excelforum.com/member.php...oamp;userid=29588
View this thread: www.excelforum.com/showthread...hreadid=492880
Range is all inclusive.

Just seems to miss random product codes.
See lookup formula in above reply....--
Mike Jenkins
------------------------------------------------------------------------
Mike Jenkins's Profile: www.excelforum.com/member.php...oamp;userid=29588
View this thread: www.excelforum.com/showthread...hreadid=492880Maybe you have spaces at the end of a few codes in the lookup table -
use TRIM() to get rid of these.

Pete
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: www.excelforum.com/member.php...oamp;userid=29050
View this thread: www.excelforum.com/showthread...hreadid=492880