Another issue of Excel.?

I have this worksheet whose 1500 products contained therein. and column D has class. And there are a total of 56 categories. What I want to do is a sub-category in column F. Is it possible to say. Find the column D and then see that it is a cordless phone then automatically fill D and office supplies? or whether it was camping equipment. be filled as outdoors? I know I could use the Yes, but only allows a few IF I have 56 categories so that the dose does not work for me.

I do not know if this answers your question, but I know that Excel, you can create lines and add a background to a cell. You can also combine two cells at the top by pressing a button, it thinks is a kind of a. I hope that helps!

Night hike gear list