Learn Excel from MrExcel - "Convert Various Currencies": Podcast #1659

In a continuation of yesterday's Podcast [Episode #1658], Bill looks closer at the Currency Conversion Table sent in by Bob. Going with a bit more advanced Excel solution, Bill employs a VLOOKUP to provide the conversion. Follow along with Episode #1659 to see a slightly different take - using a single VLOOKUP Formula. "VLOOKUP Awesome Quick: From Your First VLOOKUP to Becoming a VLOOKUP Guru" by Bill 'MrExcel' Jelen. From 'MrExcel Labs', this Enhanced eBook is designed *exclusively for the iPad*. This e-publication Includes text, audio, and video; a media-rich and in-depth look at the Excel VLOOKUP by Bill Jelen. To read more, click here: http://www.mrexcel.com/vlawsomequick.html "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of your Microsoft Excel Needs!

Comments

1. thank you Bill Jelen ,its very helpble to me
2. If you name you ranges, ie Jan, Feb, Mar, Apr etc. Then try just the "SUM" function. Ex: =Sum(Jan, Mar) to Sum together multiple non-continuous columns.
3. I thought of a single equation as well, but did nestled IF statements. Forgot all about V Lookup
4. The "ROUND" function and the "VLOOKUP" are the pillars of Excel !
5. Please let me know. I want to know. When we want to find the sum between the columns. Ex. Column A,B,C,D,E,F,G,H....ZZ To find the total column A,C,E,G,.... Without having to select each cell. I tried the formula. =Sumif(A1:OJ1),"Name",(B1:OJ1) But..It can not be used. I don't Know Thank you.