Vlookup not working

[japc90]

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.

 

[Gav123]

Hi,

Try this..

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

Hope this helps.

Gav

 

[Pete_UK]

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

 

[japc90]

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




- Show quoted text -

Worked perfect thanks!

 

[jasmine]

Have any of you had the following trouble:

I type in the vlookup formula and rather than giving me an answer, it
displays the formula i typed out. When i open the formula wizard it shows
that it is finding the correct value, but not displaying it. I have checked
cell formats and everything else.

Any ideas?

 

[Gord Dibben]

Either of two...............

1. You have set your sheet to "View Formulas" hit CTRL `(backquote) to togle
off/on.

2. The cell was pre-formatted as text and Excel thinks the formula is text.
Format to General then F2 and ENTER


Gord Dibben MS Excel MVP

 

[Pete_UK]

That's good to hear - thanks for feeding back.

Pete