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...
  • Greg_Deckler's avatar
    6 years ago

    Well, the red part is not correct:

     

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