Finding Sales based on Name and Date

Hello,

Trying to figure out how to have Excel check a table for two criteria: Name and Date

This is an example table showing Employee Names, specific non-sequential dates and the number of sales for each date.


ex.PNG

So I'd like to be able to tell Excel to fetch sales number for "Employee A" on "Date X". Is this possible at all?

I know how to use VLOOKUP but unfortunately I won't always be able to correlate the Column Index with specific dates since in my reporting they're not always sequential (as per the above example).

Thanks in advance for your assistance.

Thanks for your answer. I could not understand the coordinates but that's my fault because I cropped them from the picture I have sent.

EXX.PNG

So if I take this table into account, what formula would I need to use in order to determine Mark's sales on 16/12/2018?

Also is it OK to use a Cell value to be looked up - i.e. B2 - (if value is exactly the same in the reference table) instead of the exact content in quotation marks - i.e. "John" or "16/12/2018"?

Cheers!

Originally Posted by AliGW

=INDEX($B$2:$E$4,MATCH("John",$A$2:$A$4,0),MATCH("16/12/2018",$AB$1:$AE$1,0))

I'm not 100% clear on the logic of the formula yet. For the date, the Match content is $AB$1:$AE$1

I do not have any data on columns AB or AE. What part of the table should the date part be using as the "lookup value"? I'm trying to build the formula manually and this is the only part I cannot fathom yet.

Thanks again for you assistance!

Hello,

This worked like a charm, thank you so much!