Posted this response in your original thread in microsoft.public.excel.
---------
"Mrbanner" wrote:
....
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?

Think this orientation should now be correct ..

In Sheet2,

Put in AG2, and array-enter:
=INDEX(Sheet1!$AG$2:$AG$8000,
MATCH(1,(Sheet1!$D$2:$D$8000=D2)*(Sheet1!$J$2:$J$8 000=J2),0))
Copy AG2 down

And perhaps better with error-traps to return blanks ("") for non-matching
lines, etc, we could put instead in AG2, array-enter, and fill down:

=IF(OR(D2="",J2=""),"",
IF(ISNA(MATCH(1,(Sheet1!$D$2:$D$8000=D2)*(Sheet1!$ J$2:$J$8000=J2),0)),"",
INDEX(Sheet1!$AG$2:$AG$8000,
MATCH(1,(Sheet1!$D$2:$D$8000=D2)*(Sheet1!$J$2:$J$8 000=J2),0))))
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--