value from first column

[kiwikloud]

Hi,

Could you please tell me that how without using the formula '=B14', I can enter a function that always returns the value from the first column, second row of the above array of cells?

Thanks

[:) Sixthsense :)]

Index(Your_Range_Here,Row_Number,Column_Number)

=INDEX(A:E,2,1)

Change A:E to your desired range

[kiwikloud]

thanks a lot