VLOOKUP problem

S

Stevie D

I have been using the VLOOKUP function in a file which has been working OK.
This looks at a name range in another worksheet to produce a number.

I made a new copy of the file, but I cannot get the VLOOKUP function to
work. I am referencing all the correct cells, but instead I get '#N/A'
instead of a number. The function I am entering is:
=VLOOKUP(A12,HarJan,6,FALSE). The value I am trying to reference is in A12,
the name range is called 'HarJan', of which I want to retrieve the value in
the sixth column.

I have tried to fix this without success, including trying suggestions from
Microsoft's website (changing the formatting of the cells, truncating the
number, turning on the 'Precision as displayed' option).

I have also tried this function in other worksheets in the file, but without
success.

Can someone please help?

Steven Davidson
 
D

davesexcel

maybe you should start all over from renaming the range to writing the
formula again
 
C

CLR

Do Insert > Name > Define, and highlight the HarJan range and check the
window below to see that it still refers to the range you want to in this
current workbook instead of some other path.....

hth
Vaya con Dios,
Chuck, CABGx3
 
K

Kevin Vaughn

Try a compare to see if the data actually matches. Like if the range harjan
refers to a5:f10 and the cell that is supposed to match is in a7, try the
formula =a2 = a7
if it returns false, there is a difference. Perhaps a trailing space. Or
since it is in another worksheet, =a2 = sheet2!a7
 
D

davesexcel

Kevin said:
Try a compare to see if the data actually matches. Like if the range
harjan

The range does refer to the correct data in the current workbook.
Click to expand...

color]
Click to expand...

Did you do it over from the start??, obviously there is something wrong
if it doesn't work, which workbook has the range name?
 
Top