| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto selection
If I have a worksheet with the following info 1 2 3 4
200 80 180 500 and I give the the following info 90 490 180 201 can I get a formula to lookup the value closely to number mentioned, from the list and enter under the number (eg 200 = 201) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
auto selection
Your list, be it horizontal or vertical, must be sorted in ascending order,
then either the HLOOKUP or the VLOOKUP formulas using the "TRUE" option at the end will return the number just lower than the criteria..... hth Vaya con Dios, Chuck, CABGx3 "ekkeindoha" wrote: If I have a worksheet with the following info 1 2 3 4 200 80 180 500 and I give the the following info 90 490 180 201 can I get a formula to lookup the value closely to number mentioned, from the list and enter under the number (eg 200 = 201) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Populate Based on Other Selection | Excel Discussion (Misc queries) | |||
| auto fill columns based on a selection | Excel Discussion (Misc queries) | |||
| Turn off auto selection of cells when moving mouse | Excel Discussion (Misc queries) | |||
| # of Records Shown During Auto-Filter Selection | Excel Discussion (Misc queries) | |||
| Auto populate several cells based on a selection from drop down li | Excel Discussion (Misc queries) | |||
Linear Mode
