Need a Lookup Formula

I am in need of an advanced lookup formula that will search through data from one table and produce a value based on conditions from another table.

What I am trying to achieve is this:

If the Type in Table 1 is A and Table 2 below is A and the Centre in both tables is Cairo but if the Account in Table 1 contains any values except Bundle and Table 2 is blank and if the Price in Table 1 and 2 is 13, the allocation should be Plane but if the price in table 1 contains any value except 13 but table 2 is blank, the allocation should be Car.

enter image description here

I tried this formula but it is not working. Please help.

=IF(AND(Table1!A:A=Table2!A:A),Table2!E:E),IF(AND(Table1!B:B=Table2!B:B),Table2!E:E),IF(AND(Table1!C:C=Table2!C:C),Table2!E:E),IF(AND(Table2!C:C="",Table1!C:C<>""),Table2!E:E),IF(AND(Table1!D:D=Table2!D:D),Table2!E:E),IF(AND(Table2!D:D="",Table1!D:D<>""),Table2!E:E))))))