for each row, create a text ID to identify names of cols to right which contain numbers.

I think this is a pretty simple formula but so far I've had no luck finding an excel formula which works: I have a table with six columns. In most cells of the table there is a value of 0. But in some rows, one of the columns has a value above 0.

For each row I simply want to look to the right, determine if any of the 6 columns has a value above 0, and then return a text "label" identifying the column.

Some of the columns have identical names.

I tried a long nested series such as =if(isnumber(D2),"SSL",if(isnumber(D3),"HSL" etc etc, with the "else" statements being "". But I wasn't able to get Excel to accept the nesting to work (where to put the final commas, "", and ).

The attached workbook illustrates the prob and my desired results. Any advice? Thanks!