VLOOKUP Help

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

any214

I have a 2 worksheets, The first worksheet has only 50 people with the
following info:

A B C
Employee number Employee last name Employee first name
12345 Jones Jack

Worksheet 2 is a report sent to me everyday which has everyone in the
company on it, I need to be able to only pull the 50 people from worksheet
one from this report. I have tried to use VLOOKUP but only get an N/A in the
box. This is my formula: =VLOOKUP("'Team Williams'!",'Saraland
COB'!A2:C698,3,FALSE) Please help this is not working.
Thanks
 
Yes I could find the info using the employee numbers, that would be fine. So
would my formula look like this

=VLOOKUP('Team Williams'!B1,'Saraland COB'!A1:W694,1,TRUE)
In Team Williams B1 is where the employee ID is located.
 
That's it!

But i would still use FALSE as the match criteria because it will always
find the exact number for which you are looking, otherwise you have to make
sure that your list is ALWAYS sorted in ASCENDING order and this can cause
serious hassels with large databases.
 
My formula is only pulling the name of the last person on the worksheet with
all employees, it is not pulling the names of all the people on a certain
team. What could be wrong?
 
Back
Top