Hi!
I am struggling to determine a formula to return multiple results based on a lookup. The only examples I can find are not quite what I'm looking for. Two columns of data as the source data. I would try and explain what I'm looking for, but the sheet I have attached may give a better description. Source table on the left, desired result on the right. Let me know if I can help describe it.
Thank you!!!
Bookmarks