Hi,

Try this..

=VLOOKUP(C4,'Emp Info'!A2:B632,2,FALSE)

Hope this helps.

Gav

"japc90" wrote:

I typed the below formula:
=VLOOKUP(C4,'Emp Info'!A2:A632,2,FALSE)
It is not working. Instead of pulling back the correct name from
column B it is giving me #REF!. If I tell it to only count over 1
instead of 2 it pulls in the correct value (the same value it is
searching for). Any idea what I am doing wrong?

All assistance is appreciated.