--What is the error?

--What happens if you enter the full formula into the cell; rather than
moving around to select the range.

=VLOOKUP("lookup",[Bookname.xls]Sheet1!$A$1:$D$100,2,0)

--
Jacob (MVP - Excel)


"BG Mark" wrote:

I am trying to enter a vlookup function into a cell to look at data in
another work book, but after entering the initial lookup reference followed
by the comma, I get an error message when I try to move to the look up range
in the other work book. It may be some setting within the work book but i
cannot figure out what. I have used vlookup on many occasions and have never
seen this type of error before.