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 |
|
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 |
|
Wow, that IF was cool ! :) :) Comment from : PMSOCHO Piotr Majcher |
|
@Francis Osuna, You are welcome! Comment from : ExcelIsFun |
How To Use VLOOKUP Formula in Microsoft Excel | VLOOKUP in Excel | Excel VLOOKUP РѕС‚ : StudySpan Download Full Episodes | The Most Watched videos of all time |
VLOOKUP Complete Tutorial ( हिन्दी ) - Vlookup in excel - VLookup formula with examples РѕС‚ : Deepak EduWorld Download Full Episodes | The Most Watched videos of all time |
9 Ways to use " VLOOKUP " in Ms-Excel Telugu || VLOOKUP Tricks in Excel Telugu || Computersadda.com РѕС‚ : Computers adda Download Full Episodes | The Most Watched videos of all time |
Excel Magic Trick #94: VLOOKUP Into Web Query РѕС‚ : ExcelIsFun Download Full Episodes | The Most Watched videos of all time |
MS Excel - Vlookup in Excel Video Tutorials РѕС‚ : Tutorialspoint Download Full Episodes | The Most Watched videos of all time |
Currency Conversion Chart: JMD to USD, CAD and GBP | JMD Currency Conversion Chart (vlog 031) РѕС‚ : SideHustleMama Download Full Episodes | The Most Watched videos of all time |
How to use the VLOOKUP function in Excel РѕС‚ : TechOnTheNet Download Full Episodes | The Most Watched videos of all time |
7 Ways to Use Vlookup in Excel РѕС‚ : My E-Lesson Download Full Episodes | The Most Watched videos of all time |
MS Excel - Lookup Function РѕС‚ : Tutorialspoint Download Full Episodes | The Most Watched videos of all time |
Fully Automatic Invoice in Excel | How to Create Invoice in Excel | Bill in Excel РѕС‚ : StudySpan Download Full Episodes | The Most Watched videos of all time |