| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
OFFSET equation not working
Hi,
use vlookup =vlookup(AA9,M7:N106,2,false) Mike "Raz" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
OFFSET equation not working
There are *many* ways to do this. Here's one way assuming you're looking for
an exact match: =SUMIF(M2:M10,AA9,N2:N10) -- Biff Microsoft Excel MVP "Raz" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
OFFSET equation not working
PERFECT, Thanks again Mike
"Mike H" wrote: Hi, use vlookup =vlookup(AA9,M7:N106,2,false) Mike "Raz" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
