I am trying to search in column A and return what is in column B. My lookup value is in column D and then my table is A&B. For some reason, the vlookup formula isn't working correctly. Maybe vlookup isn't what I need. I need column D to search within column A and return multiple values from Column B.
Correction, it might need to be titled Search for text string in a cell and return adjacent values in the same cell separated by a coma.
Any help would be greatly appreciated!
Bookmarks