I have an array of data that I want to look up a specific phrase from. Once the phrase is found I would like to output the value or phrase of the cell to the direct left of the cell that’s found. I would like to be able to use this formula without explicitly naming the columns because there is not a specific column with all of the data that I need.Please let me know if I need to explain further. :)

  • Hi, welcome to WebApps. You need to supply more information, including, I suggest, some sample data for an example of the scenario that you are anticipating. If you don't want to "name the column" to be returned, then you need to explain how you propose to identify the column that you want to return.
    – Tedinoz
    Aug 14 at 8:04
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
    – Community Bot
    Aug 16 at 23:56
  • This is days old now, and there has been no response to community contributor "Tedinoz." But I agree that we'd need a link to a spreadsheet with realistic data and hand-entered "desired results" as a starting point.
    – Erik Tyler
    Aug 19 at 3:22


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy