Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comma in Function Argument name treated as separator
I am referencing an internet based workbook in a Vlookup function that has a
comma in the internet address. The problem is that Excel is treating the comma in the name as the separator for the arguments. Is there a way around this? eg. The workbook is at http://some_server_name/John Smith Company, Inc/Report.xls I am using: Vlookup(A2, 'http://some_server_name/John Smith Company, Inc/[Report.xls]Data'!$A$2:$Z$45, 8, 0) It is treating the comma between "Company" and "Inc" as the comma between "$A$2:$C$45" and "8" Thanks, Ken |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comma in Function Argument name treated as separator
Hi Ken,
You need quotes (") around the argument -- Kind regards, Niek Otten Microsoft MVP - Excel "Error trying to sort in a Macro" om wrote in message ... |I am referencing an internet based workbook in a Vlookup function that has a | comma in the internet address. The problem is that Excel is treating the | comma in the name as the separator for the arguments. Is there a way around | this? | | eg. | | The workbook is at | http://some_server_name/John Smith Company, Inc/Report.xls | | I am using: | Vlookup(A2, 'http://some_server_name/John Smith Company, | Inc/[Report.xls]Data'!$A$2:$Z$45, 8, 0) | | | It is treating the comma between "Company" and "Inc" as the comma between | "$A$2:$C$45" and "8" | | Thanks, | Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel, how do I change the argument separator in a function fr. | Setting up and Configuration of Excel | |||
How to use comma as list separator instead semicolon? | Setting up and Configuration of Excel | |||
thousand separator conversion from dot to comma | Excel Discussion (Misc queries) | |||
Comma separator for custom Currency | Excel Discussion (Misc queries) | |||
thousands comma separator in VBA | Excel Discussion (Misc queries) |