i am familiar with the sumproduct function which allows me to lookup/sum a column based on various criteria's

i want to be able to lookup a text value based on multiple conditions.

Here is the layout

columna = date
columnb = ref (not unique - number between 8 and 20)
columnc = id (either 2 or 3)
columnd is a name (text)

i want to lookup the name based on criteria for columns a to b

there is only one entry for the criteria i want to request

i have looked at vlookup but this is based on one condition