Dear All,
I have this problem.
1)how to map each other as the commonly sharing information only by
description but yet not fully mapped. for example, working table desc is
shell plate whereas update table is carbon steel - shell plate.
2) even same material in working table also can have different desc. notice
SA516, same material but different desc.

can anyone out there help me on this?
thanks alot


from this working table do subtotal and.....
desc material price
SHELL PLATE SA516 50
SHELL PLATE SA516 40
SKIRT SUPPORT SA516 30
FLANGES SA709 100
GASKETS SA123 75
GASKETS SA123 20

update in the amount field
code desc amount
21110 CARBON STEEL - SHELL PLATE 90
21130 CARBON STEEL - SKIRTS/SAD 30
21140 CARBON STEEL - PIPES
21170 CARBON STEEL - TUBE SHEET
21180 STAINLESS STEEL - FLANGES 100
21520 BOLTS/NUTS/GASKETS/SPARE 95

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