Tag Archives: MSExcel

And the winner of the VLOOKUP Great White Shark Award is…

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.


From The MS Office Blog: “VLOOKUP WEEK 2012 Wrap-Up”

From the Blog.Office.Com Excel Blog page, Microsoft’s Emily Warn puts the Wraps on “VLOOKUPWEEK 2012”

“VLOOKUP Week has ended. The brainchild of Excel MVP Bill Jelen, the idea inspired all things VLOOKUP, including VLOOKUP odes, haikus, vampires, and a way to track shark attacks. Setting all fun aside–Excel experts created a crazy number of useful and innovative applications of VLOOKUP in seven days. The week might be over, but thanks to the enthusiasm of the Excel community and to the Web, the information will continue to instruct Excel users at all levels of expertise. So thanks, Bill, and …” … To Read the Entire Blog.Office.Com entry by Emily Warn Click Here – and don’t forget to enter your vote in the poll on Emily’s post!

Click To Go & Vote In The Poll!

The Microsoft Office Blog Excel Page can be found Here: http://blogs.office.com/b/microsoft-excel/

Thank you Emily!


From ‘Smitticisms’: “IF Statements and LOOKUPS”

 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

.


Tom Urtis at Atlas Programming Management Inc: “LOOKUP Page”

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


Tom Urtis: “Lookup First and Last Values Along Row”

“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.


Tom Urtis: “Reverse Intersecting Lookup: Return Row and Header Labels”

While tidying up the storeroom for the VLOOKUP WEEK Blog… we came across a few things – this is one.

“I recently posted this example, followed by this more advanced example for finding an intersecting value in a table with multiple rows and columns.

Today it’s the opposite scenario, where you identify a value in the table and you lookup the value’s row header, column header, and while we’re at it, the address of the value. In the picture, the maximum number is identified, with its address, and header labels for Month and Salesperson.” …To Read More Click Here to go to Tom Urtis’s Lesson.


“We’re Going To Need A Bigger Week!”

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 Girvin “VLOOKUP WEEK Double Header Wrap Up!”

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

    1. See how to use a formula with INDEX and MATCH functions and Defined names to do Approximate or Exact match lookup.
    2. See formula inserted into picture for Excel 2010 and 2003.
    3. 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’: “A look at the VLOOKUP function”

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.


Crystal Long: “VLookup to Calculate Distances using Latitude & Longitude”

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