How can I match or lookup a value on Excel?

I got these 2 questions in an exam, and as easy as they sound, I couldn't get them right.

So I have this table.

And the questions are:

1- Using a function, What is the price of the first Diesel car that appears on the list?

2- Using a function, What is the brand of the second model of the list?

If anyone can help me I'd be very grateful. Thanks.