Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

How to apply vlookup with an additional condition if another column contains a word in the header of the initial table?

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.

enter image description here

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

>Solution :

You could try the following:

enter image description here


• Formula used in cell K3

=XLOOKUP(I3,$A$3:$A$4,FILTER($B$3:$D$4,ISNUMBER(SEARCH($B$2:$D$2,J3))))

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading