VLOOKUP Help!! ASAP!!

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

Tammyp

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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top