How to display a result if all the data in a row from table1 and table2 match?

Try A11:

Formula:

Please Login or Register  to view this content.

copied down.

Or, with 365,

Formula:

Please Login or Register  to view this content.

@TM: your proposals are working.

---------------------------------------------------------------------------------------------

@sandy666: What is the code if the expected result is now located in Table 1?

PS: do you create tag name manager in excel for your table before using Power Query? or do you use power query, and click on advanced editor only and write your M-code?

Blue tables = your source
Green table = expected result

so you've three tables in total

you can use formula(s) in table1 column Branche but I prefer PQ

hm, how I do that...
your two tables => Ctrl+T (Excel Tables) then Data -> From Table ==> and you've two source tables in Power Query window, next some magic steps and you have there Table 3 with a few manipulation and you can see result loaded into the sheet - green table

you know how to see M-code: select Queries from the left side then select which query you want to see and then Advanced Editor

queries.png

for more information about Power Query: https://learn.microsoft.com/en-us/power-query/

@HansDouwe,

Update: I put the function SOMME.SI.ENS instead NB.SI.ENS (translation in french of COUNTIFS function), it didn't work for this reason.

I put the thread as solved. Your proposal #3 is really great.

Thank you for your help.

maybe this:

post #3

Formula:

Please Login or Register  to view this content.

or

post #4

Formula:

Please Login or Register  to view this content.