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) |
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) |