Excel Magic Trick 1235: 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUP

Video quality	The size	Download

Information Excel Magic Trick 1235: 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUP

Title	:	Excel Magic Trick 1235: 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUP
Lasting	:	10.45
Date of publication	:
Views	:	35 rb

Frames Excel Magic Trick 1235: 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUP

Description Excel Magic Trick 1235: 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUP

Comments Excel Magic Trick 1235: 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUP

hi mike what if i want set my own customize rates stil it will work?
Comment from : Funfan’s

Love your Enthusiasm
Comment from : Mayank Rawat

D rat
Comment from : Balaji Verma

As usual, you are a genius Thanks
Comment from : More A

How to convert in specific datesall different date?
Comment from : Ami Amie

Thank you Sir for enlighten us, God bless you Your tutorials are amazing and your way of teaching is very details and clear Appreciate and thank you so much
Comment from : smarkliang1

Thanks, you solved my problem with historical exchange rates!
Comment from : Jayvee Sacramento

OMG I CAN LISTEN FOR EVER!!! I LOVE HOW FUN U MAKE IT!!!!! <3
Comment from : UarobejTube

Wow! Thanks man! Amazaing vid! <3
Comment from : UarobejTube

I am learning excel though all of your videos and it's been really helpfulbrI have excel test for an IJP, so is there a link or video related to a excel test which include all kinds of questions?
Comment from : Harshitaa Arora

I am using MarketXLS and it's great
Comment from : Harrison Delfino

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
Comment from : LongTimeTTFan

I had to use similar tricks with reports before Definitely worth noting
Comment from : MrSarky1992

+Hussein Korish , cool - so many fun ways!
Comment from : ExcelIsFun

+Excel Stuff (Felipe Vaz) , Glad you like them!
Comment from : ExcelIsFun

awesome video!! you can also use offset (starting at G3) in the same way index was used keep doing these videos!!
Comment from : Jorge Piris

Hey Mike! Thank for making this video (y)
Comment from : sikandar mohammad

Nice one Excelisfun!
Comment from : Felipe Vaz

Nice way to look up But where are the currency-signs? £ 33308, CA$ 55475, € 84519 Thanks! And greetings from the netherlands
Comment from : jurdegreeuw

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

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
Comment from : Misca Mustonen

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? ie scrap the information from a website and automatically update Marcus
Comment from : Marcus Chick