Cell references

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

Guest

I have a worksheet that contains multiple formulas. The location of the
cells that are referenced in the formulas changes frequently. e.g. Pet food
sales (A1) 123.50 (B1) the first time I do the formula; then the next month
Pet Food Sales (A3) 135.60 (B3). Is there any way to reference the cell
using the text in another cell i.e. reference B1 by its relativity to the
cell that contains the title "Pet Food Sales".

At present, I have to reset the formula each month.

Any help would be much appreciated,

Alex.
 
I am assuming that your examples are on different worksheets, when
VLOOKUP() formula would seem to suit.
Say you have "Pet Food Sales" in cell A1 in Sheet 2. To look up th
value in Sheet 1 range A1:B100 use this formula in a cell in Sheet
:-
=VLOOKUP(A1,Sheet1!$A$1:$B$100,2,FALSE
 
Back
Top