Formula for returning value in adjacent cells

Hello, I'm looking for a formula that would return the text in a cell adjacent to a search result. For example: column Q has the list of the items sold, column S is the number of items sold. I use t...