Formula stopped working?

I have an IF statement that I've been running for quite a while, here's the formula:

=IFERROR(HLOOKUP(A5,'W:\Global Currency Support\Currency Rate Reviews\CompetitorReviews\[DigikeyRateReview_08052015.xlsx]CurrenciesAndDeviantSuppliers'!$D$4:$AF$7,4,FALSE),"")

Now every week I've been using this formula, and simply changing the date in the external file as there's a new file generated every week, now for some reason this has stopped working, can anyone spot anything within the formula that would cause it to stop functioning?

Can you define "Stopped working" ?

What exactly happens, do you get an error (or "" because of the IFERROR) ?
Do you get the wrong value? What value DO you get, what value did you expect?

What do you mean by "simply changing the date in the external file" ?
Are you changing a date that already existed, say in G4, change it from 12/1/2015 to 1/1/2016 ?
Or are you ADDING new dates to the right? Does the new date exist within the referenced range (A4:AF4) ?

Originally Posted by Jonmo1

Can you define "Stopped working" ?

What exactly happens, do you get an error (or "" because of the IFERROR) ?
Do you get the wrong value? What value DO you get, what value did you expect?

What do you mean by "simply changing the date in the external file" ?
Are you changing a date that already existed, say in G4, change it from 12/1/2015 to 1/1/2016 ?
Or are you ADDING new dates to the right? Does the new date exist within the referenced range (A4:AF4) ?

Sorry, should have elaborated, when I say "change date" I simply mean I change the date in the file name in the formula, when a new file is generated it puts that days date so I simply change the filename so it uses the latest version of the external file.

Basically what the formula is giving me is a blank value, the cell is completely blank after I run the formula, when before It would give me the correct percentage.

For troubleshooting, I'd remove the IFERROR to make sure we know what the error actually is (probably #N/A)
That is pretty straight forward, means it didn't find the match for A5 in the external book in A4:AF4

I'm now wondering if my other Formula is causing the problem, does anything look odd with this VLOOKUP:

=VLOOKUP(B2,'W:\Global_Currency_Support\Currency_Rate_Reviews\CompetitorReviews\[DigikeyRateReview_01122016.xlsx]Sheet1'!$A$5:$C$19,3,FALSE)

Every week the filepath remains the same, just the date at the end of the file changes to that days date, it seems to work but then when I change the date at the end of the file path, it gives me #N/A (The file does exist I should add)

Originally Posted by FDibbins

Are you sure there is actually something to find on the other file?
If you know that teh data inhe other file really is there, check for leading/trailing spaces in the "found" cell

Yes there is data within the range of the VLOOKUP, and on the correct sheet (Sheet1), I should note that whenever I double click the formula and then enter out, it brings up the "Update Values:DigikeyRateReview_01122016.xlsx" box, and when I double click the file again in this box it just goes back to #N/A