| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup to return larger value
Try this:
Using your data in Cells A1:B9 E1: 6.5 F1: =VLOOKUP(E3,A1:A9,1,1) That finds the closest match in Col A F2: =INDEX(A1:A9,MATCH(F1,A1:A9,0)+1) Looks in A1:A9 for the value in Cell F1 and returns the next item listed after that. Is that what you're looking to do? If no...there are other approaches. *********** Regards, Ron "Christobee" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup to return larger value
thanks helpful
"Ron Coderre" wrote: Try this: Using your data in Cells A1:B9 E1: 6.5 F1: =VLOOKUP(E3,A1:A9,1,1) That finds the closest match in Col A F2: =INDEX(A1:A9,MATCH(F1,A1:A9,0)+1) Looks in A1:A9 for the value in Cell F1 and returns the next item listed after that. Is that what you're looking to do? If no...there are other approaches. *********** Regards, Ron "Christobee" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
