#NA Error on VLookup

Hi folks:
I have a small area to enter employee hours on the main dashboard of my project.
Hours.png

The lookup value is the cell with Cook1(FT) (O16)
The VLookup code I am using is

Please Login or Register  to view this content.

where Wages is a named range with position names in column 1 and wage rates in column 2.

I have read several articles about the possible cause of this error and cannot correct the problem. There are no leading spaces in the data, the cell references are all correct and both cells have a number format. I tried changing the cell formats but nothing helped. Three other cells are also VLookup formulas that work fine.

What else can I check?

Hi,
Under the formulas tab, go to Name Manager and check what the Wages named range relates to.
I am guessing that you do not want to attach the sheet, but maybe take a copy and remove any sensitive information and then attach it to this post, or re-create the issue in another workbook and attach that.