IF/OR Formula Involving Multiple Cells

[boojooo]

Hello,

Got a bit of a crazy one, I have 8 cells (A1 - D1 & A2 - D2), cells A1 - D1 are column headers and contain no formulas, while cells A2 - D2 contain formulas that will either return a value or a blank cell. Only one of the A2 - D2 cells will have a value populated for each row. I'm looking for a formula that will determine which cell has a value in it and then return the value of that cells column header. For example, if cell B2 is the only cell populated the formula will return the value in cell B1.

 

[Fluff]

If your values are numeric & greater then 0 how about
=INDEX(A1:D1,MATCH(0,A2:D2,-1))

 

[JoeMo]

Note that the formula is an Array formula and must be confirmed with ctrl+shift+enter.

Excel Workbook
	A	B	C	D	E	F
1	Hdr1	Hdr2	Hdr3	Hdr4
2		X				Hdr2
Sheet6

 

[Scott R]

=SUMPRODUCT(--(ISNUMBER(A2:D2)), A1:D1)

or

=SUMIF(A2:D2, "<>", A1:D1)

 

[boojooo]

That equation is giving me an #N/A error, though there is a value in B2.

 

[boojooo]

That formula is returning a blank value even though there is data is cell B2.

 

[JoeMo]

You've had 3 replies with different formulas to offer. Please quote the responder when you tell us what you observe when trying a formula they offered.

 

[boojooo]

Sorry about that JoeMo & Scott R. Got pulled away in a meeting and wasn't able to provide a better response. I was able to work that equation with your inputs. Thank both of you very much for your time assisting me with this brain bender!

 

[boojooo]

Also forgot to thank Fluff, thank you!

 

[JoeMo]

Sorry about that JoeMo & Scott R. Got pulled away in a meeting and wasn't able to provide a better response. I was able to work that equation with your inputs. Thank both of you very much for your time assisting me with this brain bender!

You are welcome - thanks for the reply.