Return value of adjacent raw cell if targetted raw cell met a condition

[Majidh]

Hi;

Not sure if I can explain it well...
As in the attached image, I want to return the value from the first raw (shaded in yellow), if the cell value in adjacent raws (the colurfull raws) is greater than 0.7. For example, in the column of "Which letter", the first cell "i3" should be empty because none of the adjacent raw cell has value greater than 0.7. But in the second cell "i4", the value should be "D" because it is in the the first adjacent raw cell where this raw has a cell value greater than 0.7. The third cell should return "C", and so on...
Is there any function I can use. I tried VLOOKUP & IF statement, but did not successed.

Yours

 

[kevin9999]

Here's one way:

Book1
	A	B	C	D	E	F	G	H	I
1	0.70
2			A	B	C	D	E	F	Which letter
3		1	0.10	0.14	0.18	0.22	0.26	0.30
4		2	0.40	0.50	0.60	0.70	0.80	0.90	D
5		3	0.28	0.60	0.92	1.24	1.56	1.89	C
6		4	0.04	0.20	0.36	0.52	0.69	0.85	F
7		5	0.90	0.96	1.02	1.08	1.14	1.20	A
8		6	0.44	0.60	0.76	0.92	1.08	1.24	C
Sheet1

Cell Formulas
Range	Formula
I3:I8	I3	=IFERROR(INDEX($C$2:$H$2,MATCH(TRUE,INDEX($C3:$H3>=$A$1,0),)),"")

 

[Majidh]

Here's one way:

Book1
	A	B	C	D	E	F	G	H	I
1	0.70
2			A	B	C	D	E	F	Which letter
3		1	0.10	0.14	0.18	0.22	0.26	0.30
4		2	0.40	0.50	0.60	0.70	0.80	0.90	D
5		3	0.28	0.60	0.92	1.24	1.56	1.89	C
6		4	0.04	0.20	0.36	0.52	0.69	0.85	F
7		5	0.90	0.96	1.02	1.08	1.14	1.20	A
8		6	0.44	0.60	0.76	0.92	1.08	1.24	C
Sheet1

Cell Formulas
Range	Formula
I3:I8	I3	=IFERROR(INDEX($C$2:$H$2,MATCH(TRUE,INDEX($C3:$H3>=$A$1,0),)),"")

It works
Thanks a lot for your quick help, appreciated.

 

[kevin9999]

Happy to help & welcome to the forum