Auto Populate a unit amount into # of hours

[MYbarra]

Any ideas on an equation to auto populate # of hours based on rate type and # of units? However if its hourly, I would need the hourly to stay the same and populate if I am to drag the formula to populate the column. 

Spreadsheet:

Reference table:

[#2]

@MYbarra 

=IF(VLOOKUP(A2,$A$17:$B$22,2,FALSE)="varies","varies",VLOOKUP(A2&B2,CHOOSE({1,2},$A$17:$A$22&$B$17:$B$22,$C$17:$C$22),2,0))

Is this what you are looking for?

[#3]

I'll see if I can make sense of that formula within my Excel sheet and let you know. It's definitely possible but I have never used the vlookup formula and need to determine how many data point would be required for it to work properly.