if then return the column title of first non zero cell

[kugzs]

Hi,

Ive been trying to work this out for a while but without luck.

I would like to return the column title of the first non zero cell in the row that matches another cell.

So, I would like to get % if the criteria is column A = B

_ * % & $
A 0 0 0 0
B 0 1 0 0
C 0 0 1 0
D 0 1 0 0

Thanks in advance

 

[pplstuff]

Assuming "_" is A1:

F2: =index(a1:e1,1,match(1,a2:e2,0)) <--put in absolute references and drop down. Your second row doesn't have a "1", so you might have to add some error handling.

 

[kugzs]

Thanks for the quick reply.

The non-zero value won't always be 1. Also, I dont want to have to specify the row to be examined. I want to use something like if(A1:A10=B then return the column title of the first non zero cell in the row

Thanks