Perhaps you may desire to share the error message?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"BG Mark" wrote in message
...
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.