auto increment column number with a value from different worksheet cel 2

[shoricelu]

Hi,

I have 2 worksheets in the same file of .xls.

On the second worksheet I enter in a cell a custom value. I need to extract from the first worksheet the entered row value.

EG: If I enter 2, I need to extract from the first worksheet the value from row 2, column 1.

If I enter 8, I need to extract from the first worksheet the value from row 8, column 1.

Thanks a lot!

 

[GlennUK]

One way to do this ( and there are many ways ), is to use the INDEX function:
=INDEX(Sheet1!$A$1:$A$65535,A1)

where A1 is the cell where you typed your value for row number.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[yogia]

Hi shoricelu:

Refering to solution provided by Glenn, you could simply use ...

=INDEX(Sheet1!A:A,A1)

(forgive me for nitpicking Glenn!)

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com