v lookup will do it i think
your formula will look something like this
I cant quite understand which cells you are looking for
just say C1 is the cell you are typing the product code in sheet A (and you
want to look in sheet B) in c2 sheet a type the formula
=vlookup(c1,sheetB!A1:B62,2,false)
this formula will look for the exact match of the product code you have
typed in cell c1 in col a of sheet b and return the yarn count from the cell
in col b next to the cell in col a the product code is found in.
--
paul
[email protected]
remove nospam for email addy!
"garyww" wrote:
>
> 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
> [email protected]
>
>
>
>
> --
> garyww
>
Bookmarks