Try something along the lines of this amendment,
array-entered with CSE, as befo

=IF(ISNA(MATCH(1,(TRIM(Sheet1!$A$2:$A$100)=A2&"")* (TRIM(Sheet1!$B$2:$B$100)=B2&"")*(TRIM(Sheet1!$C$2 :$C$100)=C2&""),0)),"",INDEX(Sheet1!$E$2:$E$100,MA TCH(1,(TRIM(Sheet1!$A$2:$A$100)=A2&"")*(TRIM(Sheet 1!$B$2:$B$100)=B2&"")*(TRIM(Sheet1!$C$2:$C$100)=C2 &""),0)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Secret Squirrel" wrote:
One follow up question...

Say instead of having it show a "3" if the match is true, could I have it
show another value from the detail worksheet? In column E of my detail
worksheet I have a record number. How could I show that value instead of a
"3"?