It probably would, but I think with a simple Index Match formula I could get
the result I'm looking for. The spreadsheet is already a monster and it has
pivots and validations list that I'm working to get rid off via automated
data population with these formulas.

"ryguy7272" wrote:

Won't a pivot table do it for you?



"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?