If you have a spreadsheet of items in different currencies and are doing a VLOOKUP to find the prices, you may want to return the items in £ rather than in the mixture of currencies.
In the example below, I want to create an invoice showing prices in £ but on my Items_list, they are shown in a multitude of currencies.
I have named the above as ITEMS_LIST.
I have created a Named Range called XRATE of my exchange rates.
On my invoice sheet, I am using VLOOKUP to find the relevant description for each item.
To find the price I am using a VLOOKUP to find the price in the relevant currency and combining it with an INDEX and MATCH to return the answer in £.
Find out more about our Microsoft Excel training London, UK.
Find out more about our Microsoft Excel training Wiltshire, Hampshire, Dorset.