Cell references

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to reference a cell (in a formula) by its relativity to
another cell?

e.g.
Month 1
Cell A1 - "Pet Food Sales"
Cell B1 - 123.50

Month 2
Cell A3 - "Pet Food Sales"
Cell B3 - 123.50

I am importing reports into Excel then using Excel formulas to give me the
totals etc.. Each month, the imported report could put the values I need to
reference in a different place, but always in the same relative location to
text such as "Pet Food Sales".

At present I have to rework the formulas each month.

Is there an alternative?

Thanks,
Alex.
 
That would help if the original cell reference stayed in the same place month
to month, but it doesn't! The only constant through the months is that the
text in the cell (that is relative to the one I want to reference) says the
same thing, e.g. "pet food sales".

So I guess I have two issues: using the OFFSET function to reference a
relative cell location; and being able to use the OFFSET function in such a
way that I don't have to input a cell address (A1) but can do some sort of
search by text entry to get the cell address.

I have a feeling I am asking the impossible!

Thanks for your help,
Alex.
 
Back
Top