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