JP Pinto! Congratulations!
His post was one of seven chosen by Bill Jelen as the most innovative ones published during VLOOKUP Week. He won a copy Bill Jelens book Microsoft Excel 2010 In Depth. You can find links to all seven posts and see the voting results in our wrap-up post of VLOOKUP Week. …To Read the rest of the post on the MS Office Blog, click here.
Smitty writes: “This article will focus on the appropriate use of IF statements, and also show you when it’s better to move into more robust formulas like LOOKUP, VLOOKUP, HLOOKUP & INDEX/MATCH.” …To Continue on with Smitty’s Tutorial click here
From Tom Urtis of Atlas Programming Management, Inc. we have a full page of Lookup Tutorials including VLOOKUP, HLOOKUP, Reverse LOOKUP, Min/Max LOOKUP and more. Thank you to Tom for creating this resource and allowing VLOOKUP WEEK 2012 to share it here – with all of you!
To view Tom’s Tutorials, Click Here to go to Tom Urtis’ LOOKUP Resource page
From ‘Beginning Excel’ on WordPress we have an entry into the “VLOOKUP WEEK 2012” event that looks at HLOOKUP.
“Converting color bands to the equivalent resistance value is a good example of how table lookup function can be employed. Anyone can pick a separate color for every band through a drop-down list (built from data validation facility) and Excel matches color selected to the reference table, counts and displays the resistance value.” To Read More Click Here to go to Beginning Excel’s Lesson.
Just when you thought it would be safe to go back into the VLOOKUP WEEK 2012 Archives to dig up some much needed information… More Entries! Yes, that’s right – more entries! Stay tuned for information about several new twists to the Week that won’t end: “VLOOKUP WEEK 2012”.
Entries will appear – at random – beginning April 2nd, 2012.
Mike ‘ExcelisFun’ Girvin has produced Tutorials each day this week for the VLOOKUP WEEK 2012 effort. In this post, Two (2) Videos Tutorials from Mike!
VLOOKUP WEEK 2012 Tutorial #5: “CHOOSE Function – Beginner to Advanced with 12 Examples”
“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
VLOOKUP WEEK 2012 Tutorial #6: “Excel Lookup Picture Approximate or Exact match”
See how to use a formula with INDEX and MATCH functions and Defined names to do Approximate or Exact match lookup.
See formula inserted into picture for Excel 2010 and 2003.
See formula inserted into bitmap image for Excel 2007.
You may Download the workbook at: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Find more of Mike Girvin’s Excel Tutorials at ExcelisFun On YouTube.
From ‘The Data Specialist‘ on WordPress comes an Introduction to VLOOKUP with a comparison to INDEX/MATCH:
“Since Bill Jelen (MrExcel) launched a VLOOKUP week, I figured it was a good occasion to take a look at this function and also compare it with the INDEX/MATCH alternative. In order to prevent my post from being too long, I decided to dedicate this entry to the VLOOKUP function only.” … To Read More Click Here to go to The Data Specialist’s Lesson.
From Microsoft Access MVP Crystal Long
“My VLookup video calculates distance between coordinates using VLookup to get Latitude and Longitude from a table of Zip Codes, which is available as a free download on my website. There is also Concatenation, Errors (of course) and how to fix them, Relative and Absolute References, Range Names, Transposing, VBA, Table Styles, Formatting, and Conditional Formatting.” … To Read More Click Here to go to Crystal Long’s Lesson.
Crystal Long may be found at Strive4Peace as well as on YouTube Learn Access by Crystal
Microsoft Exel MVP Charles Williams sends in his contribution to VLOOKUP WEEK.
For all you VLOOKUP junkies who can’t get enough of VLOOKUP, here is a wonderful reason to use 2 VLOOKUPs instead of 1 !!
Exact Match VLOOKUP is slow
When you have a lot of data in Excel (think 10,000 or 100,000 or 1,000,000 rows) you often need to detect when a value you are looking for does not exist in the data.
You can do this using VLOOKUP and the formula…” To continue reading Charles’ lesson click here.
Charles may be found at Fast Excel on wordPress as well as DecisionModels.com
Submitted to the VLOOKUP WEEK 2012 Blog, by Ute Simon (Microsoft PowerPoint MVP, Germany) at Office2010-Blog.de, is a German Language entry posted at the Office2010-Blog by Frank Arend-Theilen (Former Excel-MVP). This entry is a Currency Conversion Worksheet created in Excel 2010.
“Sommerzeit ist Reisezeit! Die Koffer sind schon gepackt. Da die Fahrt auch in Länder führt, die nicht zur Euro-Zone gehören, lege ich mir in Excel eine Umrechnungstabelle an, die nach Eingabe eines Eurobetrags sofort in jede Nicht-Euro-Währung umrechnet. Damit auch das richtige Währungskürzel zum ausgesuchten Land angezeigt wird, bemühe ich zusätzlich noch die Bedingte Formatierung.” …To Read More Click Here to go to Frank Arend-Theilen’s Lesson.
Ute Simon may be found on Twitter @Ute_S, at Ute-Simon.com and The Office2010-Blog.de