Lookup within a range of values
 

Have values assigned to various ranges and would like to be able enter an
amount and use a function to return the associated value.

Example: B2 is FMV and need to look at range D2:E12 to return appropriate
value from F2:F12 to B3
Can do nested 'ifs' but range is, in fact, much longer than 12 rows so that
won't really work.

Thanks for your help or suggestions.
Kindly,
- mary ann

A B C D E F
1 Fair Market Value
ALV
2 Query 1250 $1 $999 $600
3 ALV $1,000 $1,999 $850
4 $2,000 $2,999 $1,100
5 $3,000 $3,999 $1,350
5 $4,000 $4,999 $1,600
6 $5,000 $5,999 $1,850
7 $6,000 $6,999 $2,100
8 $7,000 $7,999 $2,350
10 $8,000 $8,999 $2,600
11 $9,000 $9,999 $2,850
12 $10,000 $10,999 $3,100

Lookup within a range of values
 

See your other post

--
Biff
Microsoft Excel MVP


"M. A. Halbin" <M. A. wrote in message
...
Have values assigned to various ranges and would like to be able enter an
amount and use a function to return the associated value.

Example: B2 is FMV and need to look at range D2:E12 to return appropriate
value from F2:F12 to B3
Can do nested 'ifs' but range is, in fact, much longer than 12 rows so
that
won't really work.

Thanks for your help or suggestions.
Kindly,
- mary ann

A B C D E F
1 Fair Market Value
ALV
2 Query 1250 $1 $999 $600
3 ALV $1,000 $1,999 $850
4 $2,000 $2,999 $1,100
5 $3,000 $3,999 $1,350
5 $4,000 $4,999 $1,600
6 $5,000 $5,999 $1,850
7 $6,000 $6,999 $2,100
8 $7,000 $7,999 $2,350
10 $8,000 $8,999 $2,600
11 $9,000 $9,999 $2,850
12 $10,000 $10,999 $3,100