Cell Value to Row Number

[Controller]

Hello all!

How can I get the row number of a formula to be the value of a cell?

Example:

Formula =C128, instead of typing "128" I want Excel to take that number from the value contained in another cell.

Thanks in advance

 

[Mark W.]

=INDIRECT("C"&A1)

 

[Andrew Poulsom]

Try:

=INDIRECT("C"&A1)

where A1 contains 128.

 

[Jay Petrulis]

Hi,

Use the INDIRECT function.

If A1 holds 128, then

=INDIRECT("C"&A1) will reference cell C128.

Other ways...
INDEX/MATCH
OFFSET (e.g. =OFFSET(C1,A1-1,0) will work)

 

[Controller]

Re: Thanks, thanks, thanks....

One million of thanks for the tip!

So far I had spent so many time referencing cells manually....

Best regards from the sunny Spain.

Gracias!

 

[pitaszek]

Re: Thanks, thanks, thanks....

I've got a similar question. How would you replace number 37 from formula with number contained in specific cell, A1 for example.

=VLOOKUP(E13,Parameters!$B$4:$F$[B]37[/B],5,FALSE)

Cheers,
Witold

 

[pitaszek]

Re: Thanks, thanks, thanks....

Up, up. Anyone?

I've got a similar question. How would you replace number 37 from formula with number contained in specific cell, A1 for example.

=VLOOKUP(E13,Parameters!$B$4:$F$[B]37[/B],5,FALSE)

Cheers,
Witold

 

[DWRECK1207]

Re: Thanks, thanks, thanks....

I know this post is 3 1/2 years old, but I found it very useful and it helped to answer my question. Pitaszek's question was more in-line with my own of using INDIRECT within another formula. Here's what worked for me, pitaszek:

=VLOOKUP(E13,INDIRECT("Parameters!$B$4:$F$"&A1),5,FALSE)