Going back to “VLOOKUP WEEK 2012” Mike ‘ExcelisFun’ Girvin and Bill ‘MrExcel’ Jelen look at the ‘LOOKUP’ Function. Taking cues from an email Bill received from Dan Bricklin [co-founder/inventor of VisiCalc] Bill argues the point that “=LOOKUP” is ambiguous in Microsoft Excel when the Data Set Table is ‘square’. Mike, on the other hand, thinks that “=LOOKUP” is not an ambiguous Function in that scenario; that it is intuitive and dynamic. Follow along with Episode #1550 to hear the debate and decide for yourself.
“Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!
“The Learn Excel from MrExcel Podcast Series”
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
“Unlike other lookup functions, CHOOSE lets you lookup “things” besides values: Text, Numbers, Formulas, Functions, Cell References, Ranges, Defined Names, Array Constants” You may Download the workbook at: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Mike “ExcelisFun” Girvin is really taking VLOOKUP to Task! In this 4th daily installment for VLOOKUP WEEK 2012, Mike Offers us “Approximate Match & Sorting To Reduce Exact Match Calculation Time”.
Mike ‘ExcelisFun’ Girivn checks in for day 3 of VLOOKUP WEEK 2012 with “INDEX and MATCH How To”. There are approximately 30 examples in this 1 hour ‘+’ video!
The Second Video for “VLOOKUP WEEK 2012″ from Mike “ExcelisFun” Girvin: “LOOKUP function Beginner to Advanced” covering 23 examples!!
Download the workbook for this example video at: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn about LOOKUP function:
1. Approximate Match only ( 00:40 min) 2. Table taller or equal to width, does vertical lookup ( 2:18 min) 3. Table wider than tall, does horizontal lookup ( 3:48 min) and 20 more examples contained on this video! To see the full menu of the video, visit Mike’s YouTube Site Here