Previous Topic Next Topic

I have 3 columns of numbers, if my number is between columns 1 and 2

Closed
Frustrated in Colorado - Mar 21, 2011 at 05:03 PM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Mar 22, 2011 at 01:45 AM
Hello,
I have three columns with 198 numbers in each. I want to find a formula to find if a specific number is between column 1 and 2, returns value in column 3 (see example below).

(A1) 4.290 (B1) 0.64

Col. A Col. B Col. C
3.910 3.959 0.57
3.960 4.009 0.58
4.010 4.059 0.59
4.060 4.109 0.60
4.110 4.159 0.61
4.160 4.209 0.62
4.210 4.259 0.63
4.260 4.309 0.64
4.310 4.359 0.65
4.360 4.409 0.66
4.410 4.459 0.67
4.460 4.509 0.68
4.510 4.559 0.69
4.560 4.609 0.70

If anyone knows this please help.




Related:

2 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 21, 2011 at 09:24 PM
=INDIRECT("c"&MATCH(4.29,A1:A14))
0
Answer 2 / 2
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Mar 22, 2011 at 01:45 AM
suppose
x = is your specific no.

use formula

= LOOKUP(x,A2:A198,C2:B198)

first row is assume as a header
0