Index and Match with multiple criteria and date

Hey,

New here so please bear with me!

Unfortunately I'm not in a position to upload the document I'm working with however I'll try to explain the issue.

=INDEX('PV Database'!S:S,MATCH(Main!B3,'PV Database'!E:E,0),MATCH(Main!C70,'PV Database'!O:O))

That's the current formula whereby column S contains the % discount (what I'm looking for), B3 contains the item number which is in the PV database sheet E and then column C contains the date I'm looking for in the PV database column O.

Hoping you can help! The issue is that when it's looking for the date (DD.MM.YYYY) it converts it to a number (even though formatted as a date) so returns with #REF error - how do I get around this?

Thanks in advance.

Please try of this

=IFERROR(INDEX('PV Database'!S:S,MATCH(Main!B3,'PV Database'!E:E,0),1),"")

Thanks, but that's just taken the date criterion out completely which isn't what I wanted sorry. I need to keep it in there.

can you please attached your file at least I want to see how you have arrange your data set

regards,
Rev12