VLOOKUP and IF STATEMENT Combos

Hi guys,

Thanks for the help. Despite my best efforts I haven't been able to apply your formulas to my sheet. Soren, the 256 number in your formula has been giving me trouble. Anyways, I just edited my top post and attached a new spreadsheet. This is exactly where the table and formula cells are placed in my worksheet. The table isn't fully populated at the moment, however, it will be soon enough. If you could apply the formulas you guys used to this worksheet that would be fantastic.

Again, thank you guys so much.

Ok, I have figured out the equation, however, the next equation that needs to be completed is a bit over my head as the additional number value has added complexity that I am not used to.

Basically, in the next cell over I need a formula that multiplies cell G25 by .75 if it is xxxx or by .25 if it is xxx. These data points are found below in my spreadsheet.

Thanks again!