Match help
Try this in sheet2 A1
=INDEX(sheet1!AG1:AG8000,MATCH(D1&" "&J1,sheet1!$D$1:$D$8000&"
"&sheet1!$J$1:$J$8000,0))
Enter as an array formula by pressing CTL-Shift-Enter at the same time.
then drag/copy down to row 8000
HTH
"Mrbanner" wrote:
Thanks Formula searches the way I need
But for some reason it is not Inputting the Correct Information into AG
Cells
=INDEX(Sheet1!$AG$1:$AG$8000,MATCH(1,($D$1:$D$8000 =Sheet1!D1)*($J$1:$J$8000Â*Â*=Sheet1!J1),0))
With the data I have it will not be in the same order all the time and
items and lines will be removed and added. I think this code is for if
the line stay the same
For example
On Sheet 1
D= Account Number
J= Product Code
AG= Notes
Sheet 2 is the same
D= Account Number
J= Product Code
AG= Notes
But the information inside the cells will mostly be different
And in different order.
What I needs that if Sheet1 (D & J) upto 8000 lines = (Sheet2 (D & J)
upto 8000 lines then Sheet 2 (AG) = Sheet 1 (AG)
Sorry hard to explain
In a nut shell
Sheet1 (D&J) LINE 5)
Sheet2 (D&J) LINE 800)
Both Match I have notes typed In AG(Sheet1)
Now I need these notes to be shown in Sheet2(line 800) now?
Reply
|