| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
OFFSET & MATCH
Dear All,
How can I get the following formula to work if F60:F70 isn't in order? =OFFSET(F60,MATCH('Start Sheet'!D10,F60:F70,1)-1,MATCH('Start Sheet'!H18,F60:T60,1)-1,1,1) -- Thanks in advance Regards Warren -- Regards Warren |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If And Match With a MAX and Offset | Excel Discussion (Misc queries) | |||
| Match Offset by more than one value | Excel Discussion (Misc queries) | |||
| Match Offset by more than one value | Excel Worksheet Functions | |||
| Match Value and then offset | Excel Worksheet Functions | |||
| MATCH and OFFSET | Excel Worksheet Functions | |||
Threaded Mode
