lookup formula need (2 look up and one criteria)

[ryan4646]

Hi all,

i need one urgent solution for the below matter.

In sheet one, i need to fill up unit information (column k) , from second sheet column "I" exactly
matching with "A" and "E" column. In sheet one unit (column "k") A and E column has to match with the same information at second sheet.

i am helped by this forum many times, hope this time also i will get on solution asap. cheers.