software

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: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=519670Do Insert gt; Name gt; 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
quot;Stevie Dquot; wrote:

gt; I have been using the VLOOKUP function in a file which has been working OK.
gt; This looks at a name range in another worksheet to produce a number.
gt;
gt; I made a new copy of the file, but I cannot get the VLOOKUP function to
gt; work. I am referencing all the correct cells, but instead I get '#N/A'
gt; instead of a number. The function I am entering is:
gt; =VLOOKUP(A12,HarJan,6,FALSE). The value I am trying to reference is in A12,
gt; the name range is called 'HarJan', of which I want to retrieve the value in
gt; the sixth column.
gt;
gt; I have tried to fix this without success, including trying suggestions from
gt; Microsoft's website (changing the formatting of the cells, truncating the
gt; number, turning on the 'Precision as displayed' option).
gt;
gt; I have also tried this function in other worksheets in the file, but without
gt; success.
gt;
gt; Can someone please help?
gt;
gt; Steven Davidson

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

quot;CLRquot; wrote:

gt; Do Insert gt; Name gt; Define, and highlight the HarJan range and check the
gt; window below to see that it still refers to the range you want to in this
gt; current workbook instead of some other path.....
gt;
gt; hth
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Stevie Dquot; wrote:
gt;
gt; gt; I have been using the VLOOKUP function in a file which has been working OK.
gt; gt; This looks at a name range in another worksheet to produce a number.
gt; gt;
gt; gt; I made a new copy of the file, but I cannot get the VLOOKUP function to
gt; gt; work. I am referencing all the correct cells, but instead I get '#N/A'
gt; gt; instead of a number. The function I am entering is:
gt; gt; =VLOOKUP(A12,HarJan,6,FALSE). The value I am trying to reference is in A12,
gt; gt; the name range is called 'HarJan', of which I want to retrieve the value in
gt; gt; the sixth column.
gt; gt;
gt; gt; I have tried to fix this without success, including trying suggestions from
gt; gt; Microsoft's website (changing the formatting of the cells, truncating the
gt; gt; number, turning on the 'Precision as displayed' option).
gt; gt;
gt; gt; I have also tried this function in other worksheets in the file, but without
gt; gt; success.
gt; gt;
gt; gt; 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 Vaughnquot;Stevie Dquot; wrote:

gt; The range does refer to the correct data in the current workbook.
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; Do Insert gt; Name gt; Define, and highlight the HarJan range and check the
gt; gt; window below to see that it still refers to the range you want to in this
gt; gt; current workbook instead of some other path.....
gt; gt;
gt; gt; hth
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Stevie Dquot; wrote:
gt; gt;
gt; gt; gt; I have been using the VLOOKUP function in a file which has been working OK.
gt; gt; gt; This looks at a name range in another worksheet to produce a number.
gt; gt; gt;
gt; gt; gt; I made a new copy of the file, but I cannot get the VLOOKUP function to
gt; gt; gt; work. I am referencing all the correct cells, but instead I get '#N/A'
gt; gt; gt; instead of a number. The function I am entering is:
gt; gt; gt; =VLOOKUP(A12,HarJan,6,FALSE). The value I am trying to reference is in A12,
gt; gt; gt; the name range is called 'HarJan', of which I want to retrieve the value in
gt; gt; gt; the sixth column.
gt; gt; gt;
gt; gt; gt; I have tried to fix this without success, including trying suggestions from
gt; gt; gt; Microsoft's website (changing the formatting of the cells, truncating the
gt; gt; gt; number, turning on the 'Precision as displayed' option).
gt; gt; gt;
gt; gt; gt; I have also tried this function in other worksheets in the file, but without
gt; gt; gt; success.
gt; gt; gt;
gt; gt; gt; Can someone please help?


Kevin Vaughn Wrote:
gt; Try a compare to see if the data actually matches. Like if the range
gt; harjan
gt;
gt;
gt; gt; The range does refer to the correct data in the current workbook.
gt;
gt; gt; gt; Do Insert gt; Name gt; Define, and highlight the HarJan range and check
gt; the
gt; gt; gt; window below to see that it still refers to the range you want to
gt; in this
gt; gt; gt; current workbook instead of some other path.....
gt;
gt; 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: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=519670