CONCATENATE & LOOKUP Functions


Joined
Mar 22, 2012
Messages
1
Reaction score
0
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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top