Formula to identify date and location from a table and return value

[Batley]

I have a huge amount of data which I need to search quickly with a formula here is a snip it:

Salvage by day and date.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Date	Day	SALVAGE	True Store ID	Store ID	Store Name	Depot		01/01/2023	Aberdeen	???
2	01/01/2023	Sunday	TEST	0930	930	Aberdeen	DHLSTK
3	01/01/2023	Sunday		0125	125	Altrincham	DHLSTK
4	01/01/2023	Sunday		0265	265	Ashford	DHLMER
5	01/01/2023	Sunday		0345	345	Ashton Under Lyne	DHLSTK
6	01/01/2023	Sunday		0155	155	Aylesbury	DHLMER
7	01/01/2023	Sunday		0750	750	Ballymena	DHLSTK
8	01/01/2023	Sunday		0705	705	Bangor	DHLSTK
DATA

Cell Formulas
Range	Formula
D2:D8	D2	=VLOOKUP(F2,Sheet5!C:O,12,FALSE)
E2:E8	E2	=VLOOKUP(F2,Sheet5!C:O,13,FALSE)

I want to put my formula in K1 and type date into I1 and location into J1 that would return the value "TEST" from C1 as there is a match.
I have tried IF, MATCH and can not get it to work! I know this is really simple was hoping someone would have a quick answer for me.
Thank you for your time
Sara

 

[Fluff]

How about

=FILTER(C2:C100,(A2:A100=I1)*(F2:F100=J1))

 

[Batley]

Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.