Return Multiple Lookup Values to One Cell

[excelnoob927]

I have 2 tabs. I can't vlookup because I need to be alerted if there are multiple answers for each FeatureID from the other tab. I would prefer if I could potentially have every answer populate in one cell, separated by a comma/space, but am not picky. Instead, for those that have multiple answers, it can just say "Multiple."

I have attached a spreadsheet to show you what I mean.

Thanks in advance for you assistance!

-Excelnoob

ExcelForum1.xlsxExcelForum1.xlsx

[JieJenn]

In B4, enter =IF(COUNTIF(DPOB!$B$4:$B$14,Master!A4)>1, "Multiple", IF(COUNTIF(DPOB!$B$4:$B$14,Master!A4)=1,INDEX(DPOB!$A$4:$A$14,MATCH(Master!A4,DPOB!$B$4:$B$14,0)),"")) and drag it down

[Aladin Akyurek]

Are you allowed to have a solution using a function in VBA?

[excelnoob927]

Got it. Thanks for the equation!