G
garyww
worksheet A
cell F name is called product code
cell F2 is Q921
cell F3 is Q5201
cell G name is called yarn count
but
worksheet B
cell A name is called product code same as cell F of worksheetA
Cell B name is called yarn count same as cell G of worksheetA
if user plugin cell B62 with value 1234 and cell A62 at worksheet B is
equal to worksheetA cell F2.
How it link up and automatically display on G2 and the rest...
but must be able to match and identify the product code of worksheet A
and B
in order for user to plugin lots of different number on worksheetB-
column cellB
and it will display back to worksheetA - column cellG
Is vlookup and please give formula.
thanks
please instruct!
thanks
(e-mail address removed)
cell F name is called product code
cell F2 is Q921
cell F3 is Q5201
cell G name is called yarn count
but
worksheet B
cell A name is called product code same as cell F of worksheetA
Cell B name is called yarn count same as cell G of worksheetA
if user plugin cell B62 with value 1234 and cell A62 at worksheet B is
equal to worksheetA cell F2.
How it link up and automatically display on G2 and the rest...
but must be able to match and identify the product code of worksheet A
and B
in order for user to plugin lots of different number on worksheetB-
column cellB
and it will display back to worksheetA - column cellG
Is vlookup and please give formula.
thanks
please instruct!
thanks
(e-mail address removed)