How to multiply in a Vlookup

New Contributor

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 Replies

@leebell 

In F2:

 

=E2*$D$10

 

Fill down.

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