Forum Discussion

Brianda Figueroa's avatar
Brianda Figueroa
Copper Contributor
Aug 07, 2018

Excel formula Help

Hello, 

 

I am trying to write a formula for column D that returns texts if the text in column C falls under a list of items. Basically, the texts in column C are specifics and the text I am trying to return on column D are the lists of categories. I have many categories...about 16 lists (as tables) with about 1-25 specific texts. 

excel
Formulas and Functions

5 Replies

  • Philip West's avatar
    Philip West
    Iron Contributor
    Aug 07, 2018

    Can you upload an example of what you are trying to do? It sounds like something you can solve with an index(match()) but it would be good to see exactly what you are trying to achieve.

    • Brianda Figueroa's avatar
      Brianda Figueroa
      Copper Contributor
      Aug 07, 2018

      Hi Philip,

       

      Thanks for responding! 

      I attached a simplified form of my file! Let me know if you have any other questions!

      I am trying to get column B - Product family to return "Fruits" for A2 etc

      • Philip West's avatar
        Philip West
        Iron Contributor
        Aug 08, 2018

        Do your look up tables have to be arranged like that? If you were to have 1 table, that had columns for Category and Family to look up against this becomes really easy with an index(match()) or you could do it with a vlookup if that's your preference.

         

        I've attached an example of what I mean.

Resources