Forum Discussion
Anonymous
6 years agoNot applicable
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_DecklerCommunity Champion
Well, the red part is not correct:
=LOOKUPVALUE( table1[a];table2[b];table3[b]; table4[c];table5[c]])
- AnonymousNot applicable
Thank you, it's working well !