If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
offset/match
I am trying to create an offset/match formula that pulls
data from a separate worksheet, but it is not working. is there any restrictions on this?? thx, |
#2
|
|||
|
|||
offset/match
Anon,
No, shouldn't be. You should be able to use offset and match across sheets or workbooks. Maybe post your formula and we can give you some help. Regards, Kevin wrote in message ... I am trying to create an offset/match formula that pulls data from a separate worksheet, but it is not working. is there any restrictions on this?? thx, |
#3
|
|||
|
|||
offset/match
Your question is too broad - please include more detail about what
you're trying and how it's "not working" (does that mean it gives an error? the wrong value? no value at all?). In article , wrote: I am trying to create an offset/match formula that pulls data from a separate worksheet, but it is not working. is there any restrictions on this?? thx, |
#4
|
|||
|
|||
offset/match
"Kevin Stecyk" wrote...
No, shouldn't be. You should be able to use offset and match across sheets or workbooks. ... OFFSET with first argument an external link reference would only work when the linked file is open. -- Never attach files. Snip unnecessary quoted text. Never multipost (though crossposting is usually OK). Don't change subject lines because it corrupts Google newsgroup archives. |
Thread Tools | |
Display Modes | |
|
|