Upper Spreadsheet has columns A thru O. Column D thru O have numbers sporadically listed based on the numbers from Column A.
A quick explanation is that the numbers in Column A are EPA chemical numbers. Column D thru Column O are states that place the products as restrictive in their uses. So, not all states will have the same restriction for each of the products. So, some states my not have show a number.
My intention is to have a formula in each cell in Column C that will look across the spreadsheet at each respective row and return to Column C the header state name (CA, CT, MA, MI, etc...), if there is a number listed the cells below it.
The lower spreadsheet example represents how I would like to have Column C return a response to the formula.
Hopefully, I have projected my request properly so that it is understood by anyone who can help me with this.
I have tried Isnumber, isblank and a few other formulas....but nothing came together that would work.
As always, thank you for taking time to assist me with my questions.
Bookmarks