Index Match Query

Do you mean like this?

=IF(A6=0,B6,IF(ISNA(MATCH('ASM Setting'!F6,'FIN PLAN'!$C$4:$C$99,FALSE)),"",INDEX('FIN PLAN'!$J$4:$J$99,MATCH('ASM Setting'!F6,'FIN PLAN'!$C$4:$C$99,FALSE))/Maintenance!P2))

Hope this helps.

Pete

Hi Pete,

Thanks a lot for your help.

If I would like to use index and match with 2 criteria would that work? How do I go about that?