#No Match error when using VLOOKUP

Options

I am getting a #NO MATCH error in my VLOOKUP formula which is using a date to return a Period value from an external table. The table example is below.



The formula is below. The date I am referencing in the End Date @row is definetely in the external table above.


Does anyone have any ideas why this is not working?

Tags:

Answers