CODEWITHSUNDEEP
excel
Fxs7576
Fxs7576

Reputation: 1341

Returning All the Values based on the Exact Lookups

I have a table that contains "Lookup" and "Result" columns. My goal is find a formula that can return all the values from the "Result" column which lookup contains a specific string, and store these values into a cell. Below is the example:

enter image description here

Is there a way to solve this?

I have tried using Index Match and Vlookup, but both can only return the first matched value from the "Result" column.

Upvotes: 1

Views: 212

Answers (1)

Tom Sharpe
Tom Sharpe

Reputation: 34180

So it would be this if you do have Excel 2016 / Office 365

=TEXTJOIN(",",TRUE,IF($A$2:$A$10=D2,$B$2:$B$10,""))

entered as an array formula using CtrlShiftEnter

enter image description here

Upvotes: 1

Related Questions