worksheet linkage

[garyww]

The details is please see teh attached file, you can see on the file

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


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

Now I just plugin a vlaue B62 ='15254' and I want it shows on worksheet
A - G2
but remember it must match the product code of worksheetB - cellA62
'Q921' and worksheet A cell F2 'Q92'
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.


thanks to hints

gar


+-------------------------------------------------------------------+
|Filename: samplewrapwrep4.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5240 |
+-------------------------------------------------------------------+

 

[paul]

ok lets get this straight
You want to search by the yarn count,not the product code?
You just want to see if there is a match or just the cell address of the
match?
Will there always be a match?
If there isnt a match what then
What do you want to do when you find the match?

 

[garyww]

TO paul,

ok lets get this straight
You want to search by the yarn count,not the product code?
I want to search by product code once user input the yarn count
at worksheet B, then it displays on worksheet A yarn count too.

You just want to see if there is a match or just the cell address of
the
match?
It must match of the product code, once user input the yarn count

Will there always be a match?
yes

If there isnt a match what then
if no match, then user will put the product code update it immediate.
But user only input to yarn count column.

What do you want to do when you find the 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. PLEASE SEE ATTACHED FILE
samplewrapwrep4.zip
And then you will fully understand and please hints forumla.
thanks

--


paul
(e-mail address removed)
remove nospam for email addy!

ok lets get this straight
You want to search by the yarn count,not the product code?
You just want to see if there is a match or just the cell address of
the
match?
Will there always be a match?
If there isnt a match what then
What do you want to do when you find the match?

+-------------------------------------------------------------------+
|Filename: samplewrapwrep4.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5247 |
+-------------------------------------------------------------------+