Find column header based on row value

[rtlane84]

Any help would be appreciated
I have a table like this:

	2	4	6	8
100	1.5	2.2	2.8	3.1
200	1.1	1.7	2.7	3.2
300	1.8	2.6	3.5	3.9
400	1.6	2.1	3.3	4.4

I have a lookup value for column A already. I want to find the column header for the first value found that's greater than or equal to 2. For example, if my lookup is 400, then I want to return the column header 4 since 2.1 if the first value greater than or equal to 2.

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H
1		2	4	6	8
2	100	1.5	2.2	2.8	3.1		200	6
3	200	1.1	1.7	2.7	3.2
4	300	1.8	2.6	3.5	3.9
5	400	1.6	2.1	3.3	4.4
Master

Cell Formulas
Range	Formula
H2	H2	=INDEX(B1:E1,AGGREGATE(15,6,(COLUMN(B1:E1)-COLUMN(B1)+1)/(INDEX(B2:E5,MATCH(G2,A2:A5,0),0)>2),1))

 

[rtlane84]

Thank you Fluff that worked perfectly. Can you break this down for me? The main part I'm hung up on it the array portion of the aggregate formula...(COLUMN(B1:E1)-COLUMN(B1)+1)/(INDEX(B2:E5,MATCH(G2,A2:A5,0),0)>2)

 

[Fluff]

The first part gives an array of numbers
{1,2,3,4}

The index/match returns the values in the found row
{1.1,1.7,2.7,3.2}

which is check to see if its greater than 2 & gives an array of true /false
{FALSE,FALSE,TRUE,TRUE}

The 1st array is then divided by that array to give
{#DIV/0!,#DIV/0!,3,4}

and the aggregate function then returns the smallest number ignoring errors