View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Aukerman[_2_] David Aukerman[_2_] is offline
external usenet poster
 
Posts: 14
Default VLOOKUP: Referencing worksheets whose names contain commas

Hello,

How do I make a VLOOKUP formula reference a different worksheet that has a
comma in its name? For instance, in Sheet1 I want to refer to a sheet named
"Last, First" in this way:

=VLOOKUP(A1, 'Last, First'!$A$1:$M$100, 13, TRUE)

But the comma in sheet "Last, First" seems to make the VLOOKUP function
advance the argument too early. Is there an easy fix for this?

Thanks,
--David Aukerman