Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup not working
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup not working
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup not working
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup not working
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup not working
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup not working
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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup not working
That's good to hear - thanks for feeding back.
Pete On Apr 4, 2:47*pm, japc90 wrote: Worked perfect thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup not working | Excel Worksheet Functions | |||
Vlookup not working for me. | Excel Worksheet Functions | |||
VLOOKUP not working??? | Excel Worksheet Functions | |||
Vlookup not working | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions |