Hi

I'm hoping someone can assist. I want to return the amount in the last column(amount) however I need to ensure the 3 criteria's have been met.

Thanks you in advance
Paul

=INDEX(O48:U51,MATCH(O48:O51,0),MATCH(L49,Q48:Q51, 0),Match(M49,S48:S51,0),Match(N48,O48:U48,0))

JSID Vac Claim Type Amount JSID JSID2 Vac Vac2 Claim Type Claim2 Amount
1 a 7w 1 6 a e 7w 8w 600
2 7 b f 13w 4w 1500
3 8 c g 26w 6w 2500