I have a master woksheet that I will type an item number into the sheet and
then I want to retrieve data from another worksheet. If I do a vlookup, it
will retrieve the line but my problem is on the worksheet it has multiple
lines. I need to know what formula to use.
Example:
Master Worksheet
(I enter the A1234 and the three lines appear)
A1234 This is a test
This is a big test
This is a small test
On the dataworksheet that I am pulling the info from:
A1234 This is a test
A1234 This is a big test
A1234 This is a small test
I would appreciate anyone's help.
Thanks