Need help combining two Index Match functions into one

Hello,

I need help combining the following two formulas into one.

=IF(C93="","",IFERROR(INDEX(SetMatchDates!$C$3:$C$14,MATCH(A94,SetMatchDates!$A$3:$A$14,0)),0))

AND

=IF(C93="","",IFERROR(INDEX(SetMatchDates!$H$3:$H$14,MATCH(A94,SetMatchDates!$F$3:$F$14,0)),0))

I've been scratching my head on this one for too long now.... It seems like it would be easy to use an OR function somehow so it does one Index Match OR the other but I can't seem to pin it down.

Thanks for any help you can offer!

so...what exactly is supposed to happen ? if the first is an error, try second one?

Formula:

Please Login or Register  to view this content.

Hope this helps

Hi dredwolf,

Thanks for the reply! You formula works perfectly. I can't believe it was so simple and still eluded me.

All it's doing is returning a date that matches a week number.

Thanks,

You are very welcome, and thanks for the feedback, it is much appreciated !