Need formula to lookup last posted balance using 2 criteria

[Kendoaka]

I have a formula =VLOOKUP(B1,Table1,2,TRUE) but would like to add another criteria to this formula, criteria of "Card Type".

Would like formula to return last posted balance using criteria 1 (today's date) and criteria 2 (card type).

Current Date	3/2/2023
Card 1	501.23
Date	Card Type	Balance
2/15/2023	Card 1	$901.66
2/16/2023	Card 2	$1,004.45
2/20/2023	Card 1	$850.65
2/22/2023	Card 1	$320.33
2/22/2023	Card 2	$501.23

 

[KOKOSEK]

	A​	B​	C​
1​	Current Date	20/02/2023​
2​	Card 1	850.65​
3​
4​
5​	Date​	Card Type​	Balance​
6​	15/02/2023​	Card 1​	901.66​
7​	16/02/2023​	Card 2​	1004.45​
8​	20/02/2023​	Card 1​	850.65​
9​	22/02/2023​	Card 1​	320.33​
10​	22/02/2023​	Card 2​	501.23​

	A​	B​
2​	Card 1	=SUMIFS($C$5:$C$100,$B$5:$B$100,$A$2,A5:A100,$B$1)​