I'm making a worksheet to calculate the money that needs to be paid to vendors for their services.

The services are located in Column A, titled "Vendor Services"
Column B is titled "Number of Hours"
Column C is "Vendor Charge"
I want to populate Column C with the formula affiliated with the vendor service in the same row.

So if:
A2=Jenny, Hiking Adventure
B2=3
I want C2 to auto-populate with A2's affiliated formula =IF((B2>0),(B2-1)*50+85,0) because Jenny charges $85 for the first hour and $50 each additional hour.

The resulting cell value would be C2=$185.00

I have 30 different vendor services listed at the bottom of the sheet and I've written a formula to calculate each service. I had to add a third column in which all cells contain the number 1 because the formula to calculate the service needs a reference. This array is D30:F60.

I've tried C2=VLOOKUP(A2,D30:F60,2,FALSE)

This inserts a formula that calculates the price based on the number of hours (1) in column F of the array. I need the formula to calculate the price based on column B.

How do I tell Excel to auto-populate C2 with A2's affiliated formula, using the cell value of B2 in the resulting formula?

Many thanks in advance for you help.