I have the following setup:

Worksheet A:

Contains a Table named tbl_cars

Model || Car Price
=============
Ford || 0
Honda || 0
Toyota || 0
Ferrari || 0


Worksheet B:

Contains three cells:

A1 = Honda
B1 = Car Price
C1 = 15,000

How can I create a macro that uses cells A1 and B1 to look up a proper cell in tbl_cars and then populate it with value in C1?