3/24/2023 0 Comments How to use vlookup in excelThe values in column C are the final amounts after the conversion. Next to the amounts are the currencies that the user wants to convert to. The first table includes our initial list of dollar amounts. In the example below, we have two tables that facilitate currency conversion. Let’s take a look at a real example of the VLOOKUP function being used in an Excel spreadsheet for currency conversion. Now that we know when to use the VLOOKUP function for currency conversion, let’s look at how it can be used on an actual sample spreadsheet.Ī Real Example of Using VLOOKUP for Currency Conversion For example, the ISO code for the Euro is EUR and USD for the US Dollar. ISO currency codes are an international standard that are used in banking and business. Once the lookup table is set up, we can use the VLOOKUP function to find the proper conversion rate based on the indicated ISO currency code. We can simply create a lookup table that includes the conversion rate between USD and EUR and so on. Suppose you have a list of payments in US Dollars that you would like to convert into different currencies like Euros, Yen, or British Pounds. Let’s take a look at a quick example where we can use VLOOKUP and a lookup table. Afterward, we can use the VLOOKUP function to retrieve the needed conversion rate.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |