Index/Match formula recieving #NO MATCH error message

n7teixeira

The formula I am trying to use below should looking at the Short Date column in Sheet B and if there is a match in Sheet A in the Actual End Date column than it should return the value in Sheet B column Fiscal Year.

However I keep receiving a #NO MATCH error - I have double checked all columns have the same column type Text/Number. Help pls?

=INDEX({Short date}, MATCH([Actual End Date]@row, {Fiscal year}, 0))

Paul Newcome

Are both columns set as date type columns?

n7teixeira

@Paul Newcome I had them set up as text/number columns just switched both to date and still receiving same error message..

Paul Newcome

Ok. How is the [Short Date] column being populated exactly?

n7teixeira

@Paul Newcome the short date column on sheet B was all manually input, there is no formula in the column and the column type is date.

Paul Newcome

Try re-entering the dates. It may be that they are still stored as text strings on the back end.