VLOOKUP an item that has more than one matching value?

What's the best way to lookup a value from one table, that has multiple matching values in another table? Or, perhaps to word it another way, to lookup a value using more than one criteria?

Let's say I have two tables, ProductSheet and DailyPrices. They look somewhat like this:

DailyPrices:

Date	SKU	Price
11-Jul-18	SOX	$5.25
11-Jul-18	BLT	$2.00
12-Jul-18	HAT	$4.00
13-Jul-18	SOX	$6.00

ProductSheet:

SKU	Current Price
SOX	=Latest price in price list
HAT	=Latest price in price list
BLT	=Latest price in price list

How can I lookup the *latest* price of an item in DailyPrices and return it as the current price in ProductSheet? I tried VLOOKUP but I believe what I'm looking to do is too complicated for VLOOKUP. I also tried a table-based query but couldn't get that to return what I needed either. Any suggestions? Thanks in advance!

Thanks Glenn for taking time out of your day to help me. My sample was a little simplistic, but I was able to combine what you gave me with a table-based query and get the results I'm looking for. Thank-you!

That said, could you help me understand how it works? I believe the secret sauce is in this portion:

=IFERROR(LOOKUP(2,1/($A$2:$A$14=F2),$B$2:$B$14),"")

That doesn't seem to follow the syntax for LOOKUP() in the online help, any chance you can walk me through what you've done here? Thanks again for helping me solve my problem!

A couple of alternatives that don't rely on the dates being in ascending order.

Based on the dailyprices data in columns A2:C5, criteria SKU in E2

All versions of excel from 2007 onwards (this one must be array confirmed with Shift Ctrl Enter).

=SUMIFS($C$2:$C$5,$B$2:$B$5,$E2,$A$2:$A$5,MAX(IF($B$2:$B$5=$E2,$A$2:$A$5)))

Office 365 subscription version (untested, I don't have this version at home).

=SUMIFS($C$2:$C$5,$B$2:$B$5,$E2,$A$2:$A$5,MAXIFS($A$2:$A$5,$B$2:$B$5,$E2))

Wow, that's... a little kludgey. But it works, thanks to everyone for taking the time to help!