A small tweak to the formula in Sheet1's F2 ..

Put in F2:
=IF(AND(OR($A2=Sheet2!$A$1,$A2=Sheet2!$B$1),$B2=Sh eet2!$C$1),C2,"")
Copy F2 across to G2

Put instead in F2:
=IF(C2="","",IF(AND(OR($A2=Sheet2!$A$1,$A2=Sheet2! $B$1),$B2=Sheet2!$C$1),C2,
""))

Copy F2 across to G2 (as before)

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