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
“When you are faced with a table that is scattered with values among empty cells, you might need to know the first (left-most) or last (right-most) value in that row.
In the following picture, the first value in the row is returned by the formula
=INDEX(D2:H2,MATCH(TRUE,INDEX((D2:H2<>0),0),0)), copied down as needed.” …To Read More Click Here to go to Tom Urtis’s Lesson.
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.
Microsoft Access MVP Crystal Long has Decalred that “VLOOKUP WEEK 2012” is not over yet and has decided to take VLOOKUP in another direction; today Crystal gives us a lesson in Converting VLOOKUP to Equations for MS Access!
“In my last VLOOKUP Week video, I showed you how to make a Distance Table using the VLOOKUP function in Excel. Now, we build the same thing in Access — will show you how to convert VLOOKUP equations to Access.” … 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
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.
You read correctly – 1979. In Bill’s last installment for VLOOKUP WEEK 2012, we go back to 1979…VisiCalc and the whole ’20 Functions’ available in that time! There were no IF statements and there was no VLOOKUP…but there was ‘LOOKUP’. Follow along and see where VLOOKUP began!
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.
VLOOKUP WEEK is moving along and Bill brings us another use of VLOOKUP combined with the ‘Consolidate Function’.