Looking up four conditions

[Drewmyster]

I want a formula to look up data from a cell using the following conditions;

A1=Number (e.g. 2023)
A2=Name (e.g. John)
A3=Position (e.g. first, second, last etc)

Look up table array for cell row matching A1 (column B), A2 (column C) and A3 (column D) and then return the value of cell range E:E.

Any help appreciated.

 

[Joe4]

What exactly is in column E that it is returning?
Will there always be exactly one match, or could there be none or multiple matches?

 

[Drewmyster]

What exactly is in column E that it is returning?
Will there always be exactly one match, or could there be none or multiple matches?

The data in E will be a number and there will only be one row which matches the three conditions so there should not be able other results to come from it.

So in essence, I am looking for a formula that looks up the row that contains "2023" (B), "John" (C) "First" (D) and the number that is in column E is the result the formula returns.

 

[Joe4]

If it is a number, you should be able to use a SUMIFS formula, in which you can add multiple conditions, and it will "SUM" the matching results from column E.
Since there is only one match, and column E is a number, that should return the value you want.
See: SUMIFS Function