How to make a flexible cell reference?

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

Guest

Does anyone know how to make a reference to a cell flexible. I.e. I want a
formula to get data from a cell, but want the cell to be dependant on some
other value. E.g. =C"x+1" where "x+1" is a column number dependant on the
value of x.

I sure hope anyone can help me with this!

Mark
 
Is x a cell on a worksheet?

If yes, then maybe you want something like:

=INDIRECT("C"&A1)
or
=INDIRECT("C"&A1+1)
 
You must log in or register to reply here.

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

Flexible Cell Reference 5
Can I make formulas more flexible? 3
Compound Reference 2
variable sheet name 6
Making a specific row number active from a cell entry 15
SUMPRODUCT macro 2
How to make a fluent chart for merged cells? 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top