Forum Discussion
How to multiply in a Vlookup
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
- When you use the VLOOKUP, it returns the number as text, wrap the VLOOKUP formula with the VALUE formula, e.g.
=VALUE(VOOOKUP(***,***,***))
