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.
--
Tammy


"any214" wrote:

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!!!

"'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)


--
Biff
Microsoft Excel MVP


"any214" wrote in message
...
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!!!