I have to transfer data from one table to another with 2 conditions. I can apply vlookup on country but the other one is if another column contains the word in the other table heads.
I tried something with countif and vlookup but i cannot figure it out.
In the picture you see I would like to have 10 for belgium because it contains the word "people" in column Thing; and 45 for Germany because it contains the work "cars" in column thing.
>Solution :
You could try the following:
• Formula used in cell K3
=XLOOKUP(I3,$A$3:$A$4,FILTER($B$3:$D$4,ISNUMBER(SEARCH($B$2:$D$2,J3))))

