Return most recently entered amount based on look up of several criteria

You are welcome...

You probably don't really need the extra INDEX function in there:

=LOOKUP(2,1/(($A$2:$A$100=X1)*($B$2:$B$100=X2)),$C$2:$C$100)