... trying to use the index formula ...

Alternatively, on the same set-up but using INDEX,
you could also try in say, D1:
=INDEX(Sheet2!A1:E5,MATCH(B1,Sheet2!$A$1:$A$5,0),M ATCH(A1,Sheet2!$A$1:$E$1,0
))
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----