=A6*VLOOKUP(A6,Sheet2!F6:G10,2,1)

Why is there a G in there?

I'll tell you where my data is:-

The figures are in cells B6 to B38 I want the answer to display in D6
to D38

The % charges are in a sheet called Charging Bands and they are F6 to
F9

Thanks! :)