Formula to select relevant heading based on 2 conditions

[JohnDatacom]

Trying to select the relevant heading an array.  Effectively, return first heading where there is either an "x" or "z".  So in the example below would return 4H

2H	4H	8H	1D	2D	1W
a	b	x
a	b		x	x
a	z			x	x
			c

[#2 · Accepted solution]

@JohnDatacom There's likely more than one way to achieve this. If you have Excel for MS365, here's one option:

=TAKE(TOCOL(IFS((A2:F5="x")+(A2:F5="z"), A1:F1), 2, TRUE), 1)

[#3]

@JohnDatacom 

Hi,

You can use =OR(ISNUMBER(MATCH("x",A2:A5,0)),ISNUMBER(MATCH("z",A2:A5,0))) to check whether or not the column has "x" or "z".

Then you can use INDEX and MATCH to find out the heading of the first column that satisfies this condition.

[#4]

@djclements thank you that worked perfectly.  Appreciated