dazwm
03-13-2012, 12:52 PM
On sheet 1 I would like to enter a number/text into column A. The code would then look for that number anywhere on sheet 3 and put the adjacent data in the 2 cells next to it in columns B & C. Please see example. Thanks.
I enter the number below into column A
Sheet1
*ABC9ABC123**
It looks for the same that could be anywhere on sheet 3
sheet3
*EFG290ABC123TESTDATA
After lookup from sheet 3 it adds the data that is coloured yellow in columns B & C automatically
Sheet1
*ABC9ABC123TESTDATA
I enter the number below into column A
Sheet1
*ABC9ABC123**
It looks for the same that could be anywhere on sheet 3
sheet3
*EFG290ABC123TESTDATA
After lookup from sheet 3 it adds the data that is coloured yellow in columns B & C automatically
Sheet1
*ABC9ABC123TESTDATA