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.