Return Column Heading after lookup
 

Ok guys, here's one to work those muscles. So far I have the following
formula:

SUMPRODUCT(--(Test.xls!$G$23:$G$6500=B20),--('[Test.xls]Test'!$J$23:$J$6500=F20),--('[Test.xls]Test'!$O$23:$O$6500)+--('[Test.xls]Test'!$P$23:$P$6500)+--('[Test.xls]Test'!$Q$23:$Q$6500)+--('[Test.xls]Test'!$R$23:$R$6500)+--('[Test.xls]Test'!$S$23:$S$6500)+--('[Test.xls]Test'!$T$23:$T$6500)+--('[Test.xls]Test'!$U$23:$U$6500))

This is just looking for a few criterias and return the sum of a few
columns. Now, I just want it to look if any of those columns have data
greater 0 and return the column heading for that column, it'll only be one
column out of all of those columns that will have data, now, what do i do?

Return Column Heading after lookup
 

Any ideas guys?

"Javier Diaz" wrote:

Ok guys, here's one to work those muscles. So far I have the following
formula:

SUMPRODUCT(--(Test.xls!$G$23:$G$6500=B20),--('[Test.xls]Test'!$J$23:$J$6500=F20),--('[Test.xls]Test'!$O$23:$O$6500)+--('[Test.xls]Test'!$P$23:$P$6500)+--('[Test.xls]Test'!$Q$23:$Q$6500)+--('[Test.xls]Test'!$R$23:$R$6500)+--('[Test.xls]Test'!$S$23:$S$6500)+--('[Test.xls]Test'!$T$23:$T$6500)+--('[Test.xls]Test'!$U$23:$U$6500))

This is just looking for a few criterias and return the sum of a few
columns. Now, I just want it to look if any of those columns have data
greater 0 and return the column heading for that column, it'll only be one
column out of all of those columns that will have data, now, what do i do?