Posts by Pecoflyer

Try using the FALSE switch in your VLOOKUP =VLOOKUP(A2&B2,Table1[#All],5,0) to get an exact match

You are using the TRUE switch (1)

BTW your file is "Read-Only"?

For example D8 boils down to searching the "H2-2020" string which does not exist in the first column in your range $A$2:$B$61,2,0)

Same thing for the strings searched by the other N/A results

Your result seems correct, just create a custom format like dd/mm instead of

*14/03/2001

perhaps post a sample sheet with some data and expected results? Pictures are nice to look at but useless

As you can see the solution is exactly as my example

Attaching a small sample file would help

The basics would be

=INDEX(D1:D10,MATCH(1,(A1:A10="11/12")*(B1:B10<=YOUR_DATE)*(C1:C10>=YOUR_DATE),0))

To be committed as an array formula with Ctrl+Shift+Enter

Could you please post a sheet instead of useless pictures, so we can work on it? Thanks

Perhaps explain what is not working? Post a sample sheet ( no pics please) ?