Third column value from another table

Hi!

Saw the other Q&A in this forum but somehow have not been able to get resolution on this. I have two tables as below

Table A                                      
Color        Vehicle        Utility                    

Blue          Bike                                      
Red          Bus                                
Orange    Truck                              
Yellow      Car                                 

Table B   
Color            Vehicle      Utility   
Red              Bus         City Bus   
Blue             Bike         Police Bike   
Orange        Truck        Petrol Tanker   
Yellow          Car          Taxi   

The requirement:
The third column in Table A needs to be populated by the Utility of each of the vehicles matched and taken from Table B.

Would appreciate resolution on this. Thanks in advance.