# How To Do A PayPal Currency Conversion

I don’t typically do “How To” style videos but Paypal plays a huge role in how I get paid online when I do various online work activities. So anyone not sure how, you can watch this video and learn here. Sorry about my voice I was sick when recording this.

PayPal : https://www.paypal.com/

My Blog: http://onlinemoneydairy.blogspot.ca/

Learn how to do a two way lookup to retrieve the conversion rate for currencies:
1. (00:11) Two-Way Lookup for Currency Conversion Problem Set Up
2. (01:17) Don’t use IF and AND functions to create a formula
3. (02:12) Example with INDEX and MATCH functions
4. (07:06) Example with VLOOKUP and MATCH functions

Excel Magic Trick 1235: 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX & MATCH or VLOOKUP & MATCH
Video Rating: / 5

1. We receive a wholesale rate quote from our bank twice a day and add 2.5% to determine the retail foreign exchange rate to apply to transactions that involve a currency conversion.

bron: paypal

2. thanks

3. Hi, What if i want to insert the data from cell A4 to cell J5. Saying id source currency is CAD and Target Currency is GBP, then, put a value from cell A4 into cell J5. how should i go about it.?

4. Thanks a bunch, Mike. All your videos are excellent. Very thorough explanation. Very clear demonstration. Very helpful downloadable files. And you even provide answer files. Really indebted to you.

5. awesome video!! … you can also use offset (starting at G3) in the same way index was used … keep doing these videos!!

6. Nice way to look up. But where are the currency-signs? £ 333.08, CA\$ 554.75, € 845.19. Thanks! And greetings from the netherlands.

7. sorry about my question here
i heard that the if-error fn. take more time to process so iam replaced it in my file and i think no difference
my old formula is
=IFERROR(IF(MATCH([@الطرحة];'الطرحة المقابلة'!A:A;0)>1;"موجود");IF([@الطرحة]=[@طول];"";"صنف جديد"))
my new one is
=IF(ISNA(MATCH([@الطرحة];'الطرحة المقابلة'!A:A;0));IF(ISBLANK([@الطرحة]);"";"صنف جديد");"موجود")
pls provide me if the new one is more complex or take more time to proceed
Best regards

8. For the VLOOKUP and MATCH: Can you use VLOOKUP and HLOOKUP together instead? We have rarely seen the HLOOKUP in action here?

9. Wow … that was amazing … i only used to solve it just by using array ( =Sum(\$H\$4:\$L\$8*(\$H\$3:\$L\$3=B4)*((\$G\$4:\$G\$8=C4))*A4 … then CSE

10. Great video! INDEX & MATCH is about the only lookup function you'll ever need but still the only lookup function most of the people seem to know is VLOOKUP. Also love the Bill Szysz 2-way lookup by summing solution. People that smart makes me scary… The only other ways I could've tried to solve this would've been tweaking the headers a bit & use the INTERSECT-function or put the whole table into Power Query to unpivot it which would've opened a new world of possibilities to solve this: How about a video about GETPIVOTDATA-function, Mike? That's my favorite function to use when I'm doing dashboards.

11. Interesting video, the topic got me thinking that can you populate the conversion table with current values, so it would populate with that day's exchange rate automatically? i.e. scrap the information from a website and automatically update. Marcus

12. Thanks for lesson about probably the most important functions in excel (INDEX, MATCH – of course, this is my subjective opinion) 🙂
Only for fun – here is 2-way lookup by summing ;-))
=SUM((B4&C4=\$H\$3:\$L\$3 & \$G\$4:\$G\$8)*\$H\$4:\$L\$8)*A4
CTRL+SHIFT+ENTER