A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

vlookup formula errors



 
 
Thread Tools Display Modes
  #1  
Old June 3rd, 2010, 05:01 PM posted to microsoft.public.excel.misc
BG Mark
external usenet poster
 
Posts: 16
Default vlookup formula errors

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.
  #2  
Old June 3rd, 2010, 05:10 PM posted to microsoft.public.excel.misc
Pete_UK
external usenet poster
 
Posts: 8,780
Default vlookup formula errors

What error message do you get?

Pete

On Jun 3, 5:01*pm, 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.


  #4  
Old June 3rd, 2010, 05:16 PM posted to microsoft.public.excel.misc
Jacob Skaria
external usenet poster
 
Posts: 5,952
Default vlookup formula errors

--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.

  #5  
Old June 3rd, 2010, 06:13 PM posted to microsoft.public.excel.misc
BG Mark
external usenet poster
 
Posts: 16
Default vlookup formula errors

I do apologise for not putting the error message into the question but
unfortunately i cannot at this time access the persons computer on which the
error occured but from what I remember it was basically saying something like
"Your Formula Contains an Error". I have seen this type of message before,
but not at this stage of entering the formula, it's only ever occured on
completion of the entry. I will be able to get more detials tomorrow. I did
try to enter the whole formula by typing rather than moving to the cells but
I got the same message. Thanks for all who have replied but I hope you will
be patient and try to solve my problem again tomorrow.

Mark

"Jacob Skaria" wrote:

--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.

  #6  
Old June 4th, 2010, 06:48 PM posted to microsoft.public.excel.misc
BG Mark
external usenet poster
 
Posts: 16
Default vlookup formula errors

The error message that I get is quite simply "The formula you typed contains
an error". as mentioned earlier it is the timing of the error not the error
itself as it appears in the middle of entering the formula, when I try to
move to the look up range workbook, not when the input is complete. I have
tried copying the sheet from the range workbook into the file with the lookup
formula so that I am not moving to a completely different file but the error
still occurs while moving through tabs.

"BG Mark" wrote:

I do apologise for not putting the error message into the question but
unfortunately i cannot at this time access the persons computer on which the
error occured but from what I remember it was basically saying something like
"Your Formula Contains an Error". I have seen this type of message before,
but not at this stage of entering the formula, it's only ever occured on
completion of the entry. I will be able to get more detials tomorrow. I did
try to enter the whole formula by typing rather than moving to the cells but
I got the same message. Thanks for all who have replied but I hope you will
be patient and try to solve my problem again tomorrow.

Mark

"Jacob Skaria" wrote:

--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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:18 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.