| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use an index number in a search range
Nick,
I cannot fully understand what you are looking for, but it seems to me you need the OFFSET()function. Use the expression as the 3rd argument. If your problem went down columns instead of across rows you could have also used INDIRECT(). HTH Kostis Vezerides |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a negative number in a range | Excel Worksheet Functions | |||
| Assign one number to a number range | New Users to Excel | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Program Column B to record numerical range based on number in colm | Excel Discussion (Misc queries) | |||
| Assign a dollar amount to a corresponding number in a range of num | Excel Discussion (Misc queries) | |||
Threaded Mode
