Need formula which comapres the value of 2 columns between 2 sheets and then copy the data

Hello Guys,

I need help in creating a formula.

In attached file I need a formula which compares the data of Column C (Dealer Name) and Column F (Type) of Sheet1 with Column A (Dealer Name) and Column B (Type) of Sheet2. If data in both Columns (in same row) matched then the Column C, D and E value of Sheet2 should get copied in Column G, H and I of Sheet1.

For more clarification, please check the Sheet1 where I had shown that how the data should look after the formula.

Thanks,
MG

HI,

Find the updated file.

Punnam