Posted to microsoft.public.excel.misc

Narnimar

external usenet poster

Posts: 132

Offset formula help wanted

I want better formula to get the value in a1 of a workbook than this.
=-(OFFSET([DATABASE.xlsx]CONSUMPTION!$A$2980,1,2,1,1))
The above DATABASE sheet is regularly updated and the cell value of
$A$2980 will move down. In this case this formula will not help me. The
$A$2980 has the fixed Itemname but I do not know how can I use formula. What
is the change I can do to this? Please help.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula copies when only answer is wanted	Rhino721	Excel Worksheet Functions	2	September 3rd 08 03:51 AM
Excel formula help wanted	sharpe-e	Excel Discussion (Misc queries)	3	February 27th 08 01:48 AM
Formula wanted	JohnUK	Excel Discussion (Misc queries)	9	August 2nd 07 07:02 PM
formula wanted please, I have a list of data	[email protected]	Excel Discussion (Misc queries)	10	July 1st 06 04:59 AM
offset example wanted	aussiemike	Excel Worksheet Functions	1	May 23rd 06 08:50 PM

All times are GMT +1. The time now is 05:40 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us