Complex multiple cells comparison formula

I've tried some of the basic formulas, but this is beyond me.

I have table A of 500 rows and need to compare it to table B of 2000 rows.

A	B	C	D	E
1	D6 - 1.01	Table with PC	3	Yes
2	D6 - 1.01	Bookshelf	4	No
3	D6 - 1.02	Table	5	Yes
4	D6 - 1.01	Desktop	3	Yes
5	D6 - 1.03	Sink	2	No

A	B	C	D	E
1	D6 - 1.01	Table with PC	3	Yes
2	D6 - 1.01	Bookshelf	4	No
3	D6 - 1.02a	Table	5	Yes
4	D6 - 1.01	Desktop	3	Yes
5	D6 - 1.03a	Table with PC	2	No
6	D6 - 1.03b	Sink	2	No
7	D6 - 1.03c	Sink	2	No

For example with these two, from the second table to the first. IF collumn B equal to collumn and the coresponding collumn C equal to the coresponding collumn C, return for example "yes". Then I need to check the same thing for the coresponding other collumns, but basically everything would be tied to B and C. The problem is the second table, larger one, is basically all over the place, I could manage to do this if we would be talking equal lenght tables, but I do not know what formulas I could use to check further down a row once we find an equal value.

Thanks for the response, sorry about the sloopy job of explaining things, I've tried again in this attached excel table.

I made the results simulation in both colors and text since I do not know which is easier / doable.

ALecsx.xlsx

Does anyone have any ideas?

Thanks, just had to replace , with ; otherwise it worked perfectly . Rep added