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

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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519670

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



"Stevie D" wrote:

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

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

"CLR" wrote:

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



"Stevie D" wrote:

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?

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
--
Kevin Vaughn


"Stevie D" wrote:

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

"CLR" wrote:

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



"Stevie D" wrote:

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?

Kevin Vaughn Wrote:
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.

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.....

color]

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


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519670