Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
OFFSET equation not working
Thanks all for helping me.
I believe OFFSET is used to find the number on the next column. I tried this but cant get it to work. =OFFSET(AA9,N7:N106,1,0,0) I have a number(600) in cell AA9, and that number is somewhere in the column M. I need to get the number right beside it in the (next) column N. thats it. (the OFFSET eqn should give me 666, but its giving me #REF) M N 100 111 200 222 300 333 400 444 500 555 600 666 700 777 800 888 900 999 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate working days but change working week | Excel Discussion (Misc queries) | |||
Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
OFFSET() not working within a SUMPRODUCT() when refering to a range in a pivot table | Excel Worksheet Functions | |||
offset not working | Excel Discussion (Misc queries) | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) |