On Apr 4, 8:36*am, Pete_UK wrote:
Your lookup table has been defined as only one column wide (i.e. from
A2 to A632), yet you are trying to get data from the 2nd column of
this one-column table. Change it to A2:B632 at least.

Hope this helps.

Pete

On Apr 4, 2:25*pm, 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.- Hide quoted text -

- Show quoted text -

Worked perfect thanks!