Return date following 2 succesful check in 2 other columns

[Phil13]

Good afternoon excel people!

I am struggling with my formula and thought I could do with some advices.

I have created an example below of what my spreadsheet looks like.

What is important to know:

• I have 2 spreadsheet:
• Spreadsheet 1 (which is reflected below) - I cannot change the format of this spreadsheet, as it is produced by another department, and trying to make it talk to Spreadsheet 2.
• Spreadsheet 2 - a series of unique numbers are listed;
• In column A - You can see some blanks, this is because these have been merged together: for example A2 to A5 are one single cell.
• In Column B - Same as above, except that B2 to B3 are a single cell, then B4 to B5...
• Column E - same as above.

So what do I want to do, I would like to return the dates in column E, after the 2 successful checks:

• Check 1 - Unique number matched with spreadsheet below in column A;
• Check 2 - For the specific unique number identified in the first check, check when "B" is identify in Column B
• Return - date in the same row as "B" in column B

I thought of using SUMPRODUCT, however I am getting an error, my formula looks like this:

1. =SUMPRODUCT((A:A=Unique number in other spreadsheet)*(B:B="B")*(E:E))

Potential reasons I can think of:

• The cells being merged result in a mess when excel tries to match the dates (In Column E) with the Unique Number (in Column A);
• I might need to specify to SUMPRODUCT we are dealing with dates, which might need an additional tweak;
• Sumproduct is not adapted for this, an an array would be more appropriate, but in those cases I am still struggling to write these things.

Any takers?

	A	B	C	D	E
1	Unique reference number (check 1)	Check 2	Irrelevant column 1	Irrelevant column 2	Date to return
2	0001	A			01/02/18
3
4		B			02/02/18
5
6	0002	A			03/02/18
7
8		B			04/05/25
9
10	0003	A			06/04/18
11
12		B			12/04/18
13
14	0004	A			06/04/18
15
16		B			07/04/18
17

<tbody>
</tbody>