| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset.
In case you are copying A3 across to return similarly
we would need to fix the match col in Sheet2, ie use: Sheet2!$A:$A In A3 would be: =IF(A1="","",INDEX(OFFSET(Sheet2!$1:$1,MATCH(A1,Sh eet2!$A:$A,0)-1,),2)) A3 can now be copied across -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Offset of a minumum | Excel Worksheet Functions | |||
| Macro question | Excel Worksheet Functions | |||
| Offset Function | Excel Worksheet Functions | |||
| Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
| Question for use of offset and range | Excel Worksheet Functions | |||
Hybrid Mode
