Lookup values from more than one table

[RI]

I have three tables based on the compability i have to brought the date from another two tables like if match date from one table if mismatch the date from another table. Plz Help

[RI]

Thanks for reply I found solution.

[Ahmedx]

Can you please share your demo input and expected output!

[Greg_Deckler]

@RI You can use MAXX(FILTER(...), ...) or LOOKUPVALUE and if it returns BLANK then do the same against the other table. Hard to be super specific with the information provided.