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