references

[f_ringberg]

Hi,
Say if i in a excel-file have this

=Book1!A8

This indicate colA row 8.

How can i change this to =Book1!Ax
there x is a value a enter manually to select a row

if x=2 =>> =Book1!A2
if x=10 ==> =Book1!A10

x is a value in a cell eg Book2!A1

 

[Infinity]

Try this

Index(Book1!A1:A50,A1)
Where in cell "A1", you key in the row number that you want..