VLOOKUP and table_array link

  • Thread starter Thread starter Mats
  • Start date Start date
M

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
 
Mats said:
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
Click to expand...

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

GK
 
Back
Top