Hi,

hoping someone can help me, I've been slowly learning match & index from a few different sources, starting to come together but when I use dates as one of the lookups I'm having problems, generally returning #N/A. The first time I do it it works, then if I change the lookup criteria to another date it fails.

I've attached a working example here, if you change any of the country names the formula works fine, if you type over the date criteria (G2) it returns #N/A but if you paste one of the lookup dates from column A into g2 it does work.

Any ideas!? Is it a formatting issue/is it possible to do what I want?

Any help is greatly appreciated I've been trying to figure it out for a while!

Thanks.

index_match_test.xlsx