Whoops, .. slight correction to the range refs in B1's formula:

Put in the formula bar for B1:


=IF(ISNA(MATCH($A1&COLUMNS($A$1:A1),Sheet1!$B$1:$B $100&Sheet1!$E$1:$E$100,0)
),"",INDEX(Sheet1!$A$1:$A$100,MATCH($A1&COLUMNS($A $1:A1),Sheet1!$B$1:$B$10
0&
Sheet1!$E$1:$E$100,0)))

Replace the formula in B1 with:

=IF(ISNA(MATCH($A1&COLUMNS($A$1:A1),Sheet1!$B$1:$B $1000&Sheet1!$E$1:$E$1000,
0)),"",INDEX(Sheet1!$A$1:$A$1000,MATCH($A1&COLUMNS ($A$1:A1),Sheet1!$B$1:$B$1
000&Sheet1!$E$1:$E$1000,0)))

Array-enter as before

(with ranges corrected to 1000)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----