Formula Using OR - multiple sheets

Nana250

Hello - I am using INDEX/MATCH formula to pull dates into a sheet. One particular column is different because the dates can be in one of 2 sheets. What would be the correct formula?

Current formula

=INDEX({3.1 Launched Apps Range 5}, MATCH([Content Name]@row, {3.1 Launched Apps Range 4}, 0)

markkrebs

If I'm getting the entire situation here you could check if the first date is blank and then get the other date.

so something like If(isblank(Index(Match#1),Index(Match#2),Index(Match#1))

If both dates are populated and you need both dates then youd need to modify it a bit.