Dear all, do you think if use vlookup can work?
vlookup(table a desc, table b, 2 , true)

i tried but cannot as both not exact map. even i use true also cannot.
pls help! i think need to use additional function, right?
can show me using vba lookup in different sheet?

thanks alot.



table a sheet 1

desc material price (return code here)
SHELL PLATE SA516 50 21110
SHELL PLATE SA516 40 21110
SKIRT SUPPORT SA516 30 21130
FLANGES SA709 100 21180
GASKETS SA123 75 21520
GASKETS SA123 20 21520

table b sheet 2
desc code
CARBON STEEL - SHELL PLATE 21110
CARBON STEEL - SKIRTS/SAD 21130
CARBON STEEL - PIPES 21140
CARBON STEEL - TUBE SHEET 21170
STAINLESS STEEL - FLANGES 21180
BOLTS/NUTS/GASKETS/SPARE 21520

Hi
try the following formula (entered as array formula with
CTRL+sHIFT+eNTER):
=INDEX('sheet2'!$B$1:$B$100,MATCH(TRUE,ISNUMBER(FI ND(A1,'sheet2'!$A$1:$
A$100)),0))

--
Regards
Frank Kabel
Frankfurt, Germany

"tango" schrieb im Newsbeitrag
om...
Dear all, do you think if use vlookup can work?
vlookup(table a desc, table b, 2 , true)

i tried but cannot as both not exact map. even i use true also
cannot.
pls help! i think need to use additional function, right?
can show me using vba lookup in different sheet?

thanks alot.



table a sheet 1

desc material price (return code here)
SHELL PLATE SA516 50 21110
SHELL PLATE SA516 40 21110
SKIRT SUPPORT SA516 30 21130
FLANGES SA709 100 21180
GASKETS SA123 75 21520
GASKETS SA123 20 21520

table b sheet 2
desc code
CARBON STEEL - SHELL PLATE 21110
CARBON STEEL - SKIRTS/SAD 21130
CARBON STEEL - PIPES 21140
CARBON STEEL - TUBE SHEET 21170
STAINLESS STEEL - FLANGES 21180
BOLTS/NUTS/GASKETS/SPARE 21520