X value at Distinct Y Value - Easy way to determine?

[vidyashankara]

Hi All, I need your help with a problem. Lets say I have a spreadsheet like below. I want to determine the value at which X value, A1, A2, A3, ..., etc.. crosses 0.5? Is there a formula to do this easily? For e.g., A1 reaches 0.5 at 43.4. A2 and the rest reach 0.5 at higher X values not shown here... Is there a formula to reach X and A1 and print the X value where A1 reaches 0.5 (or other specific value)?

X	A1	A2	A3	A4	A5
40	0.35	0.20	0.10	0.02	0.22
40.2	0.36	0.21	0.10	0.02	0.23
40.4	0.37	0.21	0.11	0.03	0.24
40.6	0.38	0.22	0.11	0.03	0.25
40.8	0.39	0.23	0.12	0.03	0.26
41	0.40	0.24	0.12	0.03	0.26
41.2	0.40	0.25	0.12	0.03	0.27
41.4	0.41	0.25	0.13	0.03	0.28
41.6	0.42	0.26	0.13	0.03	0.29
41.8	0.43	0.27	0.14	0.04	0.30
42	0.44	0.28	0.14	0.04	0.31
42.2	0.45	0.29	0.15	0.04	0.32
42.4	0.46	0.30	0.15	0.04	0.33
42.6	0.47	0.31	0.16	0.04	0.35
42.8	0.47	0.32	0.16	0.05	0.36
43	0.48	0.33	0.17	0.05	0.37
43.2	0.49	0.34	0.17	0.05	0.38
43.4	0.50	0.35	0.18	0.05	0.39
43.6	0.51	0.36	0.19	0.06	0.40
43.8	0.52	0.37	0.19	0.06	0.41
44	0.53	0.38	0.20	0.06	0.42
44.2	0.54	0.39	0.21	0.06	0.43
44.4	0.55	0.40	0.21	0.07	0.44
44.6	0.56	0.41	0.22	0.07	0.46
44.8	0.57	0.42	0.23	0.07	0.47
45	0.58	0.43	0.24	0.08	0.48

<colgroup><col width="56" span="6" style="width: 42pt; text-align: center;"> </colgroup><tbody>
</tbody>

 

[J.Ty.]

For A1 you can use

=INDEX($A:$A,MATCH(0.5,$B:$B))

J.Ty.

 

[vidyashankara]

thanks works like a charm!

 

[J.Ty.]

Thanks for the feedback and good luck!

J.Ty.