Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting a value within a range
What function can i use to determine a value from a range?
A B c 0 300 0.6 301 600 0.8 601 900 1.0 901 1200 1.2 So if i have a value of 500, it will compare between A & B, to provide a value C. in this case 0.8. Can someone advise me the best way to achieve this? I have already generated a VLOOKUP for columns B & C, but not sure how to get a value that is between A and B. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cond. Format Data Bars of range based on values of another range | Excel Worksheet Functions | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions |