vlookup

[Guest]

I have made this formula and the criteria is not working properly. =VLOOKUP($G$2,emplist,2,1)

G2 is the social sec # I input

emplist is the database of name, dept, ss#, title.

The right criteria appears for title & dept.

However, for the name it appears a different name other than the ss# specified. What is wrong?

 

[SamS]

On 2002-03-13 17:10, Anonymous wrote:
I have made this formula and the criteria is not working properly. =VLOOKUP($G$2,emplist,2,1)

G2 is the social sec # I input

emplist is the database of name, dept, ss#, title.



The right criteria appears for title & dept.

However, for the name it appears a different name other than the ss# specified. What is wrong?

try =VLOOKUP($G$2,emplist,2,false)

 

[Guest]

http://www.mrexcel.com/board/viewtopic.php?topic=1792&forum=2

 

[Guest]

http://www.mrexcel.com/board/viewtopic.php?topic=1777&forum=2

 

[geeitsme]

That worked, thanks.

On 2002-03-13 17:16, SamS wrote:

On 2002-03-13 17:10, Anonymous wrote:
I have made this formula and the criteria is not working properly. =VLOOKUP($G$2,emplist,2,1)

G2 is the social sec # I input

emplist is the database of name, dept, ss#, title.



The right criteria appears for title & dept.

However, for the name it appears a different name other than the ss# specified. What is wrong?

try =VLOOKUP($G$2,emplist,2,false)