Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup within a range of values
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup 3 matching values of which one is a range and return a sum | Excel Worksheet Functions | |||
i wish to lookup values in column A, & add adjacent values in colu | Excel Discussion (Misc queries) | |||
Lookup a Canada postal code in a range of values | Excel Worksheet Functions | |||
How do I use LOOKUP to return a range of values, then SUM values? | Excel Worksheet Functions | |||
How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) |