VLOOKUP Help

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
 
A

any214

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

BSc Chem Eng Rick

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

any214

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?
 

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

Similar Threads


Top