Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Can't tell you what's happening with you but the syntax for VLOOKUP stayed
the same between the two versions. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "YV" wrote in message ... 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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Findlink Error | Links and Linking in Excel | |||
Error when entering and exiting excel | Excel Discussion (Misc queries) | |||
Downloading Templates for Excel error with a windows error. | Excel Discussion (Misc queries) | |||
#N/A error with VLOOKUP | Excel Discussion (Misc queries) | |||
How to set Error Bars to _two_ SDs? | Charts and Charting in Excel |