D
David Aukerman
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
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