I need a formula to pull data from multiple cells into a single cell based on common criteria in each row.
For example: I have a stock number for every color each of my products comes in. They all have the same name however. I am trying to make a catalog in publisher by merging data from an excel sheet. So I need a formula that will match the product name and pull the colors and stock numbers for all of the rows with that specific name into one cell.
Bookmarks