Thread
:
Lookup within a range of values
View Single Post
#
2
Posted to microsoft.public.excel.misc
T. Valko
external usenet poster
Posts: 15,768
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
Reply With Quote
T. Valko
View Public Profile
Find all posts by T. Valko