CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsgoogle-sheets-formula
Raman Singh
Raman Singh

Reputation: 79

Search Name in 2 cells and return the value in third cell if the name matches

I would like to create a formula in my Google Sheet where I put the name of any person in one cell then the data related to that person/'s should populate against that cell (in a single cell only)

I'm attaching an image for reference Request to share the possible solution for the above problem.

Thank you

I tried Vlookup but it is not showing up all the details and not working as well.

=TEXTJOIN(", ",TRUE,IF($E$2=$A$2:$A$12,$B$2:$B$12,""))

I tried the above Formula but it didn't work.

Upvotes: 1

Views: 63

Answers (1)

luismsobotyk
luismsobotyk

Reputation: 46

VLOOKUP just returns the first occurrence, altought you can use TEXTJOIN and FILTER to make that. Take a look at that:

=TEXTJOIN(", ";TRUE;FILTER(B2:B12;E2=A2:A12))

You can read more about that functions here:

Upvotes: 2

Related Questions