You can see on the file samplewrapwrep4.zip

Worksheet B of B62, I then typed 15254", it col name "yarn count"
and the product code you can see is Q921 at cell A62 is same row 62.

Worksheet A, you can see F2 is Q921, col name is "product code".

Now if i input a value on cell B62 ='15254' and I want it shows o
worksheet
A - G2 but remember it must match the product code of
worksheetB - cell A62 'Q921' and worksheet A cell F2 'Q921'
because next time user will plugin a number ie.1111 on B164; where
product code of worksheet B - cell A164
must be match to worksheet A - cell F3, but it should show the value
1111 on cell G3.

To match Which mean user input the yarn count on that row
WorksheetB- A62 is product code and input B62 yarn count,
so it lookup the worksheet A -F2,
it found match the product code of worksheet B - A62.
Then the input of the yearn count from worksheet B62 will
automatically display also at G2 of worksheet A as well.
And then you will fully understand and please hints forumla.
thank

+-------------------------------------------------------------------

+-------------------------------------------------------------------

--
garyww