VLOOKUP Help!! ASAP!!

[any214]

I am trying to pull data from two different spreadsheets. Spreadsheet one has
names from entire company, spreadsheet two has names for a particular group.
I want to pull the names of this particular group from spreadsheet one. This
is my VLOOKUP formula
VLOOKUP("'Employee Last Name'!,""Employee First Name'",'Saraland
COB'!A2:C698,3,FALSE)
I keep getting a #N/A error
I don't know what I am doing wrong. Someone Please help!!!

 

[Tammyp]

Make sure that your lookup sheet is in alphabetical order and use the
absolute value in your vlookup formula.

 

[T. Valko]

"'Employee Last Name'!,""Employee First Name'",

Not sure what that's supposed to mean but it doesn't look right to me.

Is Employee Last Name a sheet name? Maybe you mean something like this:

'Employee Last Name'!A1

Where A1 on the sheet named Employee Last Name holds the employee name.

=VLOOKUP('Employee Last Name'!A1,'Saraland COB'!A2:C698,3,0)