Prev: SUMIF using 2 cells that equal each other
Next: 2nd Y Axis
From: readystate on 4 Feb 2010 15:47
I have a series of FROM/TO ratings in a table (see below). I want to build a
formula for my spreadsheet that will automatically capture the ADJ Rating
whenever the number falls within the From/To Range. Any suggestions? Thanks
in advance.

Range (from / to) Adj Rating
0.01 0.95 As Is
0.96 0.99 1.00
1.00 1.03 1.05
1.04 1.05 1.10
1.06 1.09 1.15
1.10 1.15 1.20
1.16 1.20 1.25
1.21 1.25 1.50
1.26 3.00 2.00

From: RussellT on 4 Feb 2010 18:15
Assuming your table start at cell A1 and the number you want to lookup in in
Cell D2 the forumula in E2 would be:
=vlookup(D2,$A2:$C10,3,False)
the ,false return error if number in cell E2 in not within the comfines of
A2:B10

"readystate" wrote:

> I have a series of FROM/TO ratings in a table (see below). I want to build a
> formula for my spreadsheet that will automatically capture the ADJ Rating
> whenever the number falls within the From/To Range. Any suggestions? Thanks
> in advance.
>
> Range (from / to) Adj Rating LookupCol FormulaCol
> 0.01 0.95 As Is .98 =vlookup(D2,$A2:$C10,3,False)
> 0.96 0.99 1.00
> 1.00 1.03 1.05
> 1.04 1.05 1.10
> 1.06 1.09 1.15
> 1.10 1.15 1.20
> 1.16 1.20 1.25
> 1.21 1.25 1.50
> 1.26 3.00 2.00
>
 | 
Pages: 1
Prev: SUMIF using 2 cells that equal each other
Next: 2nd Y Axis