#No Match error when using VLOOKUP

DLanca

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?

DLanca

fixed this... saw a post suggesting to insert a column to the left of the Primary column and it worked 👍️