Assuming that the data you supplied is consistent, you will need some
sort of lookup table like this (used "code" to align columns):-
Code:
--------------------
desc material code Desc2
SHELL PLATE SA516 21110 CARBON STEEL - SHELL PLATE
SHELL PLATE SA516 21110 CARBON STEEL - SHELL PLATE
SKIRT SUPPORT SA516 21130 CARBON STEEL - SKIRTS/SAD
FLANGES SA709 21180 STAINLESS STEEL - FLANGES
GASKETS SA123 21520 BOLTS/NUTS/GASKETS/SPARE
GASKETS SA123 21520 BOLTS/NUTS/GASKETS/SPARE
--------------------
--
BrianB
------------------------------------------------------------------------
BrianB's Profile:
http://www.excelforum.com/member.php...info&userid=55
View this thread:
http://www.excelforum.com/showthread...hreadid=273116