LOOKUP unique data from multiple columns where search string appears multiple times

{ 2 Comments }

In a list with multiple occurrences, the VLOOKUP() function in Excel will only return the first occurrence of the string being searched.  Furthermore,  the VLOOKUP() function returns data from one column only.

To work with a list where there are multiple occurrences of a particular string and data has to be extracted from multiple columns, you may refer to my solution in this workbook.

To work with a list where there are multiple occurrences of a particular string and data has to be extracted from one column only, you may refer to my solution at this link.

Leave a Comment

Your email address will not be published.

*

  • Is it possible to do a search for certain text, and then return the value in a cell, say 2 cells below and 31 cells to the right of the cell where that text is found? For example, I have an excel sheet where the term “Sales” appears 30 times, always in column C. Each time a cell with “Sales” in column C occurrs, I would like excel to return be the value 2 down and 31 to the right of that cell. Is this possible?

    Thanks for your help.