Lookup and Return Multiple Values in Google Sheets

[@ilyik]

I've been trying to do this with multiple rows for days, and your video helped me do it! Finally! Thank you!

[@SheetsHelp]

Alright! Glad to hear it.

[@usa__md9271]

Perfect! Thank you

[@SheetsHelp]

NP, glad it helped!

[@varun5170]

It's really helpful, thank you
Looking forward to more videos

[@SheetsHelp]

Thanks! I'll be making a lot more coming up.

[@TheRealOne24]

This was exactly what I needed, thank you. Now I'm trying to auto generate a list based on these terms. Say you want to make a list using those terms any time Richard's name is found?

[@SheetsHelp]

The function will update if it gets new data so you should be alright as long as the range inputs are right.

[@TheRealOne24]

@@SheetsHelp Thanks. I can get it to fill the one cell, but I was hoping to have it continue filling in cells below it as it found the search terms.