Help Finding Specific cell

Hi

Im trying to get specific cell value but failed. What im trying to find is there are these values in sheet one.

Untitled2.jpg

And in sheet two i have to find out if account type is n in cell a2 , match b2 with sheet 1 and check for value next to it and bring it.

lets say if accoutn type is n and came is Car 1, go sheet1 check n first than find car1 and bring the value (2) into added value cell in sheet 2


Untitled.jpg

can u help me about these please ?