vlookup then multiply the value by 25%

Need to multiple the answer to the vlookup by 25 percent after it finds the value can this be done

eg. it finds the answer of $100 which then needs to be multiplied by 25% = $25 so the answer in my cell should read $125.

Please Login or Register  to view this content.

TIA

Try this ...

=VLOOKUP(A128,'[Supplier Master Price List.xlsm]Sundry'!$B:$D,2,0)*1.25

Thank you so much it looks so easy now I don't know why I couldn't see that.

You are welcome!