VLook up not Working

I have an excel spreadsheet with multiple tabs.

The first tab name is: '01-06-17 Details'

The fourth tab I am working on is named: '2017-01-11 to Review'.


Tab '01-06-17 Details' has the following columns:
iPaas Developer | Dell Boomi ID | IT SME

The '2017-01-11 to Review' tab has the field: Dell Boomi ID and I would like to bring IT SME into this spreadsheet.

When I try the following VLook up formulas nothing happens. I do not even get an error message:

=IFERROR(VLOOKUP($A2,'01-0617 Details'!A:C,3,FALSE),"No Match")
=VLOOKUP(A5,'01-06-17 Details'!A2:C230,3,TRUE)


Any help would be appreciated.

Work OK for me. perhaps post a sample file.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.