Offset formula help wanted

  • Thread starter Thread starter Narnimar
  • Start date Start date
N

Narnimar

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.
 
Acually not working if Itemname moved from $A$2980 while I update the
DATABASE. Because my formula is not searching for Itemname's address.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula help 5
OFFSET Formula 5
External reference for Offset formula 2
OFFSET and external workbook references 3
Trailing 30 days sum calculation with excel 1
OFFSET PROBLEM 2
Array formula 4
Unexpected (?) behaviour of OFFSET() in array formulas 11

Back
Top