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


In F2:




Fill down.

When you use the VLOOKUP, it returns the number as text, wrap the VLOOKUP formula with the VALUE formula, e.g.