How to multiply in a Vlookup

[leebell]

Hi, In this sheet i need to use a Vlookup to multiply the cost per kilogram in euros section, by the EUR/GBP exchange rate, how would i do this?

[#2]

@leebell 

In F2:

=E2*$D$10

Fill down.

[#3]

When you use the VLOOKUP, it returns the number as text, wrap the VLOOKUP formula with the VALUE formula, e.g.
=VALUE(VOOOKUP(***,***,***))