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
 

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

Cell references 3
Define Name - same name for multiple cells on multiple sheets 6
Use Vlookup to store formulas? 6
Data Consolidation formula 1
Using 'If' refer to specific words in a cell containing text 5
Rolling totals 1
evaluate a concatenate expression 3
Worksheet relative reference 3

Back
Top