Hi I am sure this has already been answered somewhere but I couldnt find the exact same case.
Was trying to create formula that will search a column 2 for multiple criteria and then output the info that corresponds to it from column 1, in multiple rows. The search column 2 has blank rows sometimes that would need to be ignored.
Attached is example of what I am trying to do. Thanks in advance!
Excel.png
Bookmarks