Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Lookupvalue with multiple conditions

Hello everyone,

 

I need retreive the field [a] from the table1 with a multiple conditions :

table2[b]=table3[b] and table4[c]=table5[c]

The example of my query is below :

=LOOKUPVALUE( table1[a];table2[b];table3[b]; table4[c];table5[c]])

 

When I write my query like this I have an error msg, can you please help me ?

 

Thank you !

 

 

  • Well, the red part is not correct:

     

    =LOOKUPVALUE( table1[a];table2[b];table3[b]; table4[c];table5[c]])

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Well, the red part is not correct:

     

    =LOOKUPVALUE( table1[a];table2[b];table3[b]; table4[c];table5[c]])

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you, it's working well !