Forum Discussion

RI's avatar
RI
Frequent Visitor
3 years ago

Lookup values from more than one table

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

 

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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.

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    3 years ago

    Can you please share your demo input and expected output!

  • RI's avatar
    RI
    Frequent Visitor
    3 years ago

    Thanks for reply I found solution.