Check if multiple values exist in other columns

[Wishmaster89]

Hi

I want to check that both ID and Date from the right side match the value in the columns on the left. If both matches are true i want to vlookup(the easy bit!) to return programme name into column I.

I have tried using a match statement but can't get it to work.

Can any one help please?

if and match.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	ID	Date	programme				ID	Date	programme
2	123	01/11/2021	maths				222	01/12/2021	4		Yes
3	333	01/02/2022	english				123	01/11/2021			Yes
4	222	01/12/2021	history				333	01/02/2022			Yes
Sheet1

Cell Formulas
Range	Formula
I2	I2	=IF(MATCH(G2,A:A,0),(MATCH(H2,B:B,0)),"no match")
K2:K4	K2	=IF(MATCH(H2,B:B,0),"Yes","No")

 

[Wishmaster89]

@etaf It works, thank you again. I didn't know you could have multiple lookup values for match.

 

[etaf]

you are welcome