Lookupvalue with multiple conditions

[Ait-james]

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 !

[Greg_Deckler · Accepted solution]

Well, the red part is not correct:

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

[Ait-james]

Thank you, it's working well !