Assuming your lookup table has the following form:
A........B..............C
Date....Name....Value
1/7......Capone..18
etc

Then the following ARRAY formula will do:
=OFFSET($C$1, MAX(ROW(1:100)*--($A$2:$A$101=a13)*--($B$2:$B$101=H3)),
0)

This means that you must use the key combination Shift+Ctrl+Enter to
commit.

HTH
Kostis Vezerides