vlookup with date criteria.

[Godders199]

Hello, i am trying to get the following formula to work.
=INDEX('QA Oversight file'!J:J,MATCH(1,IF('QA Oversight file'!G:G, ">="&COA!$M$2,IF('QA Oversight file'!G:G, "<="&COA!$N$2,IF('QA Oversight file'!A:A,"="&A4,1))),0))

Effectively i need to return the text in column J:J, where the date in column G:G is between the dates in M2 and N2 , then the name in column A:A equals A4. all i am able to return is "0".

So Effectively a Vlookup =VLOOKUP(A4,'QA Oversight file'!A:J,10,FALSE) but with the date criteria between M2 and N2

There will only ever be one matching record within the date range.

I have tried both as an array and as a normal formula.

Any help appreciated.

 

[Fluff]

Duplicate to: vlookup with date criteria.

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.