Looking up Multiple fields if a certain cell has a value >1

[eyeope]

Hi,

Screen Shot 2014-12-12 at 11.17.39.png

I'm looking for some help with a formula. In column D I would like to grab the value from Row 2, if the right column has a value >1.

For example. If I look at Row 7, there are values > 1 under column "TV & Film" J:K (Merged cell), Column " Society & Culture" O:R, Column "Business" W:X, Column "Comedy" Y:Y.

In D7 I would like to automatically update it to find the right Category, so if it has a number >1 then "TV & Film, Society & Culture, Business, Comedy". Since they all have values.

Hope this makes sense,

Many Thanks,

Screen Shot 2014-12-12 at 11.17.39.png

[davesexcel]

Can't work with a Tiny picture, why would you not attach a sample workbook?
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic