| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find number within a range
Hello-
My example data looks like this: A1 B1 C1 1 4 100 5 9 200 10 12 300 In D10 I have value of 3. I would like to create formula if D10 is greater than A1 but less than B1 then select C1. So in this example it would be 100 thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA: find number of columns in named range? | Excel Discussion (Misc queries) | |||
| How to find the number of value within a range? | Excel Worksheet Functions | |||
| How to find the number of value within a range? | Excel Discussion (Misc queries) | |||
| Find a negative number in a range | Excel Worksheet Functions | |||
| find the cell above any number in any range | Excel Worksheet Functions | |||
Threaded Mode
