VLOOKUP and table_array link

[Mats]

Hi,


=VLOOKUP(A9;[Book2]Sheet1!$A:$B;2;FALSE)

Is it possible to change the [book2] above so it is looking in to a cell and
reading this value instead.


I would like to stear which file the vlookup is looking in.

/Mats R Andersson

 

[GK]

Hi,


=VLOOKUP(A9;[Book2]Sheet1!$A:$B;2;FALSE)

Is it possible to change the [book2] above so it is looking in to a cell and
reading this value instead.


I would like to stear which file the vlookup is looking in.

/Mats R Andersson

If I understand your question correctly, you can substitute the
following for "Book2" CELL("contents",A100) where A100 contains a
valid name.

GK