View Single Post
  #5   Report Post  
Max
 
Posts: n/a
Default

Oops, sorry, this is just for the records ..
(forgot to fix the range references for the array formula in A2)

Put instead in the formula bar for A2:

=IF(COUNTBLANK(Sheet2!A2:C2)<0,"",IF(ISNA(MATCH(S heet2!A2&Sheet2!B2&Sheet2!
C2,Sheet1!$A$2:$A$100&Sheet1!$B$2:$B$100&Sheet1!$C $2:$C$100,0)),"",INDEX(She
et1!$G$2:$G$100,MATCH(Sheet2!A2&Sheet2!B2&Sheet2!C 2,Sheet1!$A$2:$A$100&Sheet
1!$B$2:$B$100&Sheet1!$C$2:$C$100,0))))

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