Im currently working on developing a pricing system mainly based for VLookup/ MATCH searching through different price tables dependent on user defined units sizes. There is a possibility that all unit prices will be multiplied by 30% if the 'Shaped' column has a 'Yes' selected and Im wondering the best syntax / way to incorporate this into what Ive already done - without having to reinvent the wheel. This is the current formulae

=IF([Toughened]="No",INDEX(Bonnet!$H$4:$L$15,MATCH([Area],Bonnet!$F$4:$F$15,1),MATCH($J$1,Bonnet!$H$3:$L$3,0)),INDEX(Bonnet!$H$21:$L$32,MATCH([Area],Bonnet!$F$21:$F$32,1),MATCH($J$1,Bonnet!$H$20:$L$20,0)))

Toughened = a column within the pricing sheet - this has its own table of prices
Area = a column within the sheet - specify unit size which helps find the value within the tables
Bonnet = is the name of the worksheet all the value tables are on

Any help would be great