| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup for smallest number?
Hello,
If your data is sorted (as you show it): Route First Last 521 =INDEX(Source!B:B,MATCH(A2,Source!A:A,)) =LOOKUP(2,1/(A2=Source! A:A),Source!B:B) 522 =INDEX(Source!B:B,MATCH(A3,Source!A:A,)) =LOOKUP(2,1/(A3=Source! A:A),Source!B:B) .... Regards, Bernd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Based on Next Smallest Number | Excel Discussion (Misc queries) | |||
| Looking for the smallest number that isn't less than zero | Excel Worksheet Functions | |||
| RETREIVING THE SMALLEST NUMBER | Excel Worksheet Functions | |||
| smallest missing number | Excel Discussion (Misc queries) | |||
| How to highlight the smallest number other than zero | New Users to Excel | |||
Hybrid Mode
