Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup to return larger value
I have the following PSD data. In addition to the largest number less or
equal to the lookup value I would like lookup to also give me the smallest value larger than or equal the lookup value on another cell Size (mm) % Passing 1.7 0.16 2.8 0.47 4.75 1.25 6.7 2.04 8 3.61 10 11.44 13.2 38.09 19 72.57 25 94.51 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return a range of cells from a vertical lookup | Excel Worksheet Functions | |||
need Lookup table to return null or zero | Excel Worksheet Functions | |||
Return cell reference of lookup value | Excel Worksheet Functions | |||
Lookup with multiple value return | Excel Worksheet Functions | |||
How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) |