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