Vlookup and & Functions

[lsm33000]

Good Day,

I am trying to figure out a formula that look at two separate cells and if both cells meet a specific parameter, they return a third cell. Please see attached table. in the first sheet, we have our date table. The second sheet would display certification due. I'm thinking a vlookup to cells in column A and Row 1 on the second sheet, returning name and certs/dates (cell E in first sheet). What i want displayed is written in red. However, I can't figure out the formula.

Please help if you can. Thank you.