Match formula displays #N/A

[k1989l]

Hi, i was just wondering if anyone can help me and point out where i am going wrong. I have a formula that i need to match the date in a cell with an array of cells, it looks fine but it just gives me a #N/A error.

Please Login or Register  to view this content.

Thanks in advance.

Katy

[pjwhitfield]

What does the data look like in K1 and column A?

[k1989l]

What does the data look like in K1 and column A?

I have attached a sample

[pjwhitfield]

You dont need to TEXT part of the formula

Please Login or Register  to view this content.

Please note however this will still return #NA aqs your test value (05/12/2016) is not in the list

[k1989l]

You dont need to TEXT part of the formula

Please Login or Register  to view this content.

Please note however this will still return #NA aqs your test value (05/12/2016) is not in the list

Thankyou, obviously i was over complicating it!