Nested ifs statement

[Stclements1]

I am looking for a solution that I believe maybe nested IFS but I think there maybe a better solution.
In cells J1:J9 I have values 0, 10000, 50000,100000,250000,5000000,750000,1000000,5000000
In cells K1:K9 I have values 10, 12, 12.5, 13,13.5,14,15,16,18
In cell B1 I want to select a value from J1:J9 and in cell C1 dispaly a corresponding number from the array K1:K9
I have done this by using the formula =INDEX($k$1:$k$9;MATCH(B1;$j$1:$j$9;0)
What I realised that if a number was input that wasn't relative to the values in the array J1:J9 then I it would return an error.
So what I want to do is to be able to input any number in cell B1 and then an if statement along the lines if B1>0,but less than<10000, K1 and so on so if B1>10000 <50000, etc but I'm not sure how to put all theses values into one formula.

 

[Joe4]

You can use VLOOKUP with approximate values.
See: How to Use VLOOKUP on a Range of Values

 

[Eric W]

Just remove the 0 parameter in the MATCH:

=INDEX($k$1:$k$9;MATCH(B1;$j$1:$j$9;0))

=INDEX($k$1:$k$9;MATCH(B1;$j$1:$j$9))

 

[Stclements1]

Just remove the 0 parameter in the MATCH:

=INDEX($k$1:$k$9;MATCH(B1;$j$1:$j$9;0))

=INDEX($k$1:$k$9;MATCH(B1;$j$1:$j$9))

Wasn't expecting it to be that easy, many thanks.

 

[Eric W]

Glad we could help. The parameter in MATCH (and VLOOKUP) can make a big difference.