Forum Discussion
Solved
Formula to select relevant heading based on 2 conditions
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 ...
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)
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.