VLOOKUP Help!! ASAP!!

  • Thread starter Thread starter any214
  • Start date Start date
A

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!!!
 
Make sure that your lookup sheet is in alphabetical order and use the
absolute value in your vlookup formula.
 
"'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)
 
Back
Top