Update:

It seems that the function as I wrote it *evaluates* correctly, but while
I'm typing it in, the tooltip (that helps me determine which argument I'm
entering) advances too soon when the comma in the sheet name is entered.
Maybe this is a bug?

--David Aukerman


"David Aukerman" wrote:

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