Hello All!

I have a table with data for various Floors (18th - 25th). If entered properly the data in each cell should either be #N/A or a number (typically 1 - 5). Therefore any cell with text in it (example: 1ab) would count as an error. Since there are over 30k lines, I wrote the following formula to detect any errors that need to be fixed.

Formula: copy to clipboard 
{=IF(OR(NOT(ISNA(Table2[@[Paper 18th Floor]:[Paper 25th Floor]])),(ISNUMBER(Table2[@[Paper 18th Floor]:[Paper 25th Floor]]))),"Error","")}


Then I got to thinking about It'd be nice that instead of just saying Error, it would say the Floor where the error was (example: Error: 18th Floor). I wrote up the following formula to address the issue.

Formula: copy to clipboard 
=INDEX(Table2[[#Headers],[Paper 18th Floor]:[Paper 25th Floor]],MATCH(AF2,Table2[@[Paper 18th Floor]:[Paper 25th Floor]],0))


Both formulas work, however I'd like to combine them into one cell. So that the first formula would take the place of AF2 in the second to find the errors (if any), and return the column heading. However, I can't seem to get it working.

Any ideas?

Thanks in advance.