Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 22nd 04, 06:53 PM
YV
 
Posts: n/a
Default Vlookup Syntax Error

I have been using vlookup like crazy when I had Office XP but now since
upgrading to Office 2003 my vlookup syntax is missing the commas and gives me
an error message each time I try to use vlookup. Under help commas are
showing for the syntax but my commas seems to be missing. It's not
functioning in Office 2003. Does anyone know the solution to this problem?

  #3   Report Post  
Old December 22nd 04, 07:19 PM
Frank Kabel
 
Posts: n/a
Default

Hi
post the formula you have used

--
Regards
Frank Kabel
Frankfurt, Germany

YV wrote:
I have been using vlookup like crazy when I had Office XP but now
since upgrading to Office 2003 my vlookup syntax is missing the
commas and gives me an error message each time I try to use vlookup.
Under help commas are showing for the syntax but my commas seems to
be missing. It's not functioning in Office 2003. Does anyone know
the solution to this problem?



  #4   Report Post  
Old December 22nd 04, 09:43 PM
YV
 
Posts: n/a
Default

Please find a solution for the Vlookup Error the Syntax for Vlookup is
VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup)

The Syntax is showing
The Syntax that is showing in Excel 2003 on my spreadsheets is:
VLOOKUP(lookup_value table_array col_index_num range_lookup)

It will not allow me to calculate a Vlookup formula. I just upgraded to
Office 2003. The Vlookup formula was working fine in Office XP. I repaired
and uninstalled and reinstalled and Microsoft Office 2003 but style having
the same problem


"Frank Kabel" wrote:

Hi
post the formula you have used

--
Regards
Frank Kabel
Frankfurt, Germany

YV wrote:
I have been using vlookup like crazy when I had Office XP but now
since upgrading to Office 2003 my vlookup syntax is missing the
commas and gives me an error message each time I try to use vlookup.
Under help commas are showing for the syntax but my commas seems to
be missing. It's not functioning in Office 2003. Does anyone know
the solution to this problem?




  #5   Report Post  
Old December 22nd 04, 09:49 PM
YV
 
Posts: n/a
Default

The commas are missing from the Syntax

"Frank Kabel" wrote:

Hi
post the formula you have used

--
Regards
Frank Kabel
Frankfurt, Germany

YV wrote:
I have been using vlookup like crazy when I had Office XP but now
since upgrading to Office 2003 my vlookup syntax is missing the
commas and gives me an error message each time I try to use vlookup.
Under help commas are showing for the syntax but my commas seems to
be missing. It's not functioning in Office 2003. Does anyone know
the solution to this problem?






  #6   Report Post  
Old December 22nd 04, 10:09 PM
Frank Kabel
 
Posts: n/a
Default

Hi
have you checked your Windows regional settings for this PC?.

--
Regards
Frank Kabel
Frankfurt, Germany

YV wrote:
Please find a solution for the Vlookup Error the Syntax for Vlookup is
VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup)

The Syntax is showing
The Syntax that is showing in Excel 2003 on my spreadsheets is:
VLOOKUP(lookup_value table_array col_index_num range_lookup)

It will not allow me to calculate a Vlookup formula. I just upgraded
to Office 2003. The Vlookup formula was working fine in Office XP. I
repaired and uninstalled and reinstalled and Microsoft Office 2003
but style having the same problem


"Frank Kabel" wrote:

Hi
post the formula you have used

--
Regards
Frank Kabel
Frankfurt, Germany

YV wrote:
I have been using vlookup like crazy when I had Office XP but now
since upgrading to Office 2003 my vlookup syntax is missing the
commas and gives me an error message each time I try to use vlookup.
Under help commas are showing for the syntax but my commas seems to
be missing. It's not functioning in Office 2003. Does anyone know
the solution to this problem?



  #7   Report Post  
Old December 22nd 04, 11:19 PM
RWN
 
Posts: n/a
Default

What exactly do you mean?
Is it a case of opening a prior version's workbook and having the comma's missing or are
you having them drop off after you've entered a vlookup statement?
As Frank has noted, I'd be looking first to the Regional Settings in Windows (just to be
sure).

--
Regards;
Rob
------------------------------------------------------------------------
"YV" wrote in message
...
The commas are missing from the Syntax

"Frank Kabel" wrote:

Hi
post the formula you have used

--
Regards
Frank Kabel
Frankfurt, Germany

YV wrote:
I have been using vlookup like crazy when I had Office XP but now
since upgrading to Office 2003 my vlookup syntax is missing the
commas and gives me an error message each time I try to use vlookup.
Under help commas are showing for the syntax but my commas seems to
be missing. It's not functioning in Office 2003. Does anyone know
the solution to this problem?






  #8   Report Post  
Old December 23rd 04, 12:18 AM
Gord Dibben
 
Posts: n/a
Default

YV

I can replicate this if my Windows Regional and Language settings are set for
"List Separator" = <space

StartSttingsControl PanelRegional and Language OptionsRegional Options
tabCustomizeNumbers tab. At "List separator" make sure you have a comma
entered.

If not there, perhaps you have a <space(you can't have nothing). Delete that
and enter a comma.

Gord Dibben Excel MVP

On Wed, 22 Dec 2004 13:43:09 -0800, "YV" wrote:

Please find a solution for the Vlookup Error the Syntax for Vlookup is
VLOOKUP(lookup_value,table_array,col_index_num,ra nge_lookup)

The Syntax is showing
The Syntax that is showing in Excel 2003 on my spreadsheets is:
VLOOKUP(lookup_value table_array col_index_num range_lookup)

It will not allow me to calculate a Vlookup formula. I just upgraded to
Office 2003. The Vlookup formula was working fine in Office XP. I repaired
and uninstalled and reinstalled and Microsoft Office 2003 but style having
the same problem


"Frank Kabel" wrote:

Hi
post the formula you have used

--
Regards
Frank Kabel
Frankfurt, Germany

YV wrote:
I have been using vlookup like crazy when I had Office XP but now
since upgrading to Office 2003 my vlookup syntax is missing the
commas and gives me an error message each time I try to use vlookup.
Under help commas are showing for the syntax but my commas seems to
be missing. It's not functioning in Office 2003. Does anyone know
the solution to this problem?





  #9   Report Post  
Old December 23rd 04, 02:39 PM
YV
 
Posts: n/a
Default

Thank you Gord Dibben that was it. It's fixed it was my settings. Thank you
everyone

"Gord Dibben" wrote:

YV

I can replicate this if my Windows Regional and Language settings are set for
"List Separator" = <space

StartSttingsControl PanelRegional and Language OptionsRegional Options
tabCustomizeNumbers tab. At "List separator" make sure you have a comma
entered.

If not there, perhaps you have a <space(you can't have nothing). Delete that
and enter a comma.

Gord Dibben Excel MVP

On Wed, 22 Dec 2004 13:43:09 -0800, "YV" wrote:

Please find a solution for the Vlookup Error the Syntax for Vlookup is
VLOOKUP(lookup_value,table_array,col_index_num,ra nge_lookup)

The Syntax is showing
The Syntax that is showing in Excel 2003 on my spreadsheets is:
VLOOKUP(lookup_value table_array col_index_num range_lookup)

It will not allow me to calculate a Vlookup formula. I just upgraded to
Office 2003. The Vlookup formula was working fine in Office XP. I repaired
and uninstalled and reinstalled and Microsoft Office 2003 but style having
the same problem


"Frank Kabel" wrote:

Hi
post the formula you have used

--
Regards
Frank Kabel
Frankfurt, Germany

YV wrote:
I have been using vlookup like crazy when I had Office XP but now
since upgrading to Office 2003 my vlookup syntax is missing the
commas and gives me an error message each time I try to use vlookup.
Under help commas are showing for the syntax but my commas seems to
be missing. It's not functioning in Office 2003. Does anyone know
the solution to this problem?





  #10   Report Post  
Old December 23rd 04, 05:28 PM
Gord Dibben
 
Posts: n/a
Default

YV

Thanks for the feedback.

I noticed Frank pointed you there also.

Gord

On Thu, 23 Dec 2004 06:39:09 -0800, "YV" wrote:

Thank you Gord Dibben that was it. It's fixed it was my settings. Thank you
everyone

"Gord Dibben" wrote:

YV

I can replicate this if my Windows Regional and Language settings are set for
"List Separator" = <space

StartSttingsControl PanelRegional and Language OptionsRegional Options
tabCustomizeNumbers tab. At "List separator" make sure you have a comma
entered.

If not there, perhaps you have a <space(you can't have nothing). Delete that
and enter a comma.

Gord Dibben Excel MVP

On Wed, 22 Dec 2004 13:43:09 -0800, "YV" wrote:

Please find a solution for the Vlookup Error the Syntax for Vlookup is
VLOOKUP(lookup_value,table_array,col_index_num,ra nge_lookup)

The Syntax is showing
The Syntax that is showing in Excel 2003 on my spreadsheets is:
VLOOKUP(lookup_value table_array col_index_num range_lookup)

It will not allow me to calculate a Vlookup formula. I just upgraded to
Office 2003. The Vlookup formula was working fine in Office XP. I repaired
and uninstalled and reinstalled and Microsoft Office 2003 but style having
the same problem


"Frank Kabel" wrote:

Hi
post the formula you have used

--
Regards
Frank Kabel
Frankfurt, Germany

YV wrote:
I have been using vlookup like crazy when I had Office XP but now
since upgrading to Office 2003 my vlookup syntax is missing the
commas and gives me an error message each time I try to use vlookup.
Under help commas are showing for the syntax but my commas seems to
be missing. It's not functioning in Office 2003. Does anyone know
the solution to this problem?








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Findlink Error D Moniz via OfficeKB.com Links and Linking in Excel 0 January 20th 05 04:53 PM
Error when entering and exiting excel Randy Excel Discussion (Misc queries) 1 January 11th 05 03:17 PM
Downloading Templates for Excel error with a windows error. Lanie Moore Excel Discussion (Misc queries) 0 December 20th 04 11:39 PM
#N/A error with VLOOKUP Michelle Tucker Excel Discussion (Misc queries) 4 December 14th 04 01:23 PM
How to set Error Bars to _two_ SDs? [email protected] Charts and Charting in Excel 1 December 7th 04 02:00 AM


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

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017