IF and VLOOKUP

Hello

I hope that I can explain this easily, but this is my first post so please be gentle!

I have a fully working spreadsheet which acts as our pricing matrix. However, I have been tasked with adding a percentage increase to those prices if certain criteria are met on a previous worksheet.

Its a simple yes or no (drop down cell created) that leads to an uplift of 25% in price on the next worksheet along. However the difficulty comes in that the pricing is generated by the use of a vlookup. So in short I need a formula to say its just simply the result of the vlookup if the previous answer was no, or if the answer to the previous questions is yes, then its the vlookup*1.25

I hope that all makes sense?

I look forward to hearing from an oracle!

Kind regards

John

=if('Otherworksheet'!A1="Yes",1.25,1)*vlookup([lookupvalue],[lookup array],[column number],0)

Where 'Otherworksheet'!A1 references your dropdown cell.

Should work.

Ok I have attached an example spreadsheet. The 'details' sheet is where the yes or no question is, results is the sheet I need amending and the data comes from the 'data' sheet

Thanks

John

Thats worked, thank you very much for your help

^_^ Great!