For my class, I have to use a lookup function to get the current exchange rate for that country on my worksheet. Here's the text that reads:
"Nest the CONCATENATE function inside the lookup function to concatenate the currency label with in US Dollars to find exact matches with labels in the Currency Lookup table, and calculate the U.S. dollar equivalents." - "On the Itenerary & Currency worksheet, add columns that will calculate the equivalent of $10, $50, $100 in the local currencies for each stop."
It doesn't really make much since these two functions would just return a text right? I'm thinking there's a SUM IF function nested in there somewhere but I just can't figure it out.
Any help would be incredibly appreciated. Thanks!
View attachment Tour.zip
"Nest the CONCATENATE function inside the lookup function to concatenate the currency label with in US Dollars to find exact matches with labels in the Currency Lookup table, and calculate the U.S. dollar equivalents." - "On the Itenerary & Currency worksheet, add columns that will calculate the equivalent of $10, $50, $100 in the local currencies for each stop."
It doesn't really make much since these two functions would just return a text right? I'm thinking there's a SUM IF function nested in there somewhere but I just can't figure it out.
Any help would be incredibly appreciated. Thanks!
View attachment Tour.zip