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.

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.

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.

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!

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

Pete

On Apr 4, 2:47*pm, japc90 wrote:

Worked perfect thanks

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?

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

On Fri, 4 Apr 2008 15:01:01 -0700, jasmine
wrote:

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?