VLOOKUP not working for sheet 1 called "2016" in "Jobs.xlsx"

Hello,

Can anyone help me with this. VLOOKUP doesn't work on sheet "2016" but works fine for sheet "2015". Greatly appreciate the help!

Here is the code:

=IFERROR(IFERROR(VLOOKUP(D14,'\\SERVER\data\Company Standard\TIME SHEET\Jobs\[Jobs.xlsx]2016'!B1:C300,2,FALSE),VLOOKUP(D14,'\\SERVER\data\Company Standard\TIME SHEET\Jobs\[Jobs.xlsx]2015'!B1:C300,2,FALSE)), " ")

Here is a screenshot, can't really attach the workbook, my company won't allow it, but any troubleshooting tips?

the empty space in column C is actually bunch of company information I had to cut out for privacy.

sheet.jpg

For troubleshooting purposes only, I'm looking at just the vlookup without the iferror.
VLOOKUP(D14,'\\SERVER\data\Company Standard\TIME SHEET\Jobs\[Jobs.xlsx]2016'!B1:C300,2,FALSE)

Do either of these work
VLOOKUP(D14+0,'\\SERVER\data\Company Standard\TIME SHEET\Jobs\[Jobs.xlsx]2016'!B1:C300,2,FALSE)
VLOOKUP(D14&"",'\\SERVER\data\Company Standard\TIME SHEET\Jobs\[Jobs.xlsx]2016'!B1:C300,2,FALSE)

OK, that was just troubleshooting, Don't use that as solution.

What that tells us is the values in column B of sheet 2016 are NOT really numbers.
They're "Numbers Stored As Text"

So if D14 is a real number, but the matching number in column B is a Number Stored As Text
Then they DO NOT Match.

You'll need to convert them to real numbers.
Highlight Column B.
On the Data Tab, click Text to Columns
Chose Delmininated - Next
UNcheck all options and click Finish.

See if that helps.

I see the difference between the sheets now Columb B for other sheets had =Value(.......), while 2016 did not.

Originally Posted by Jonmo1

OK, that was just troubleshooting, Don't use that as solution.

What that tells us is the values in column B of sheet 2016 are NOT really numbers.
They're "Numbers Stored As Text"

So if D14 is a real number, but the matching number in column B is a Number Stored As Text
Then they DO NOT Match.

You'll need to convert them to real numbers.
Highlight Column B.
On the Data Tab, click Text to Columns
Chose Delmininated - Next
UNcheck all options and click Finish.

See if that helps.

Thank you so much Jonmo1, you always come through.

You're welcome