Hello all,

I have finally given up and decided to ask for some help please...

Where I have come unstuck is trying to always 'round up to the nearest 500' (never down) within a VLOOKUP calc.

Currently I have a work around as follows (Cell X3);
=VLOOKUP(E3,'Mat & Finish £ Guide'!G:H,2,FALSE)*AC3/1000

G - Material Type
H - £ per linear meter

Cell AC3;
=CEILING(I3,500)

Is there a way of incorporating the calculation in AC3 into Cell X3?

Thank you for any time and assistance.

Tom