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