Category Archives: Basic VLookup Information

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!


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


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.


Mike Girvin: “Approximate Match & Sort To Reduce Match Calc Time”

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

Download the sample workbook at: http://people.highline.edu/mgirvin/ExcelIsFun.htm

 

Find more of Mike Girvin’s Excel Tutorials at ExcelisFun On YouTube.


Charles Williams: “Why 2 VLOOKUPS are better than 1 VLOOKUP”

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


Bill Jelen: “Consolidate and Lookup”

VLOOKUP WEEK is moving along and Bill brings us another use of VLOOKUP combined with the ‘Consolidate Function’.


Mike ‘ExcelisFun’ Girvin: “INDEX and MATCH How-To”

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!

Example Files are available – Download files: https://people.highline.edu/mgirvin/ExcelIsFun.htm


Rahim Zulfiqar Ali: “Getting Started with New Ideas on LOOKUP”

From Rahim’s Post:
 
The Excel lookup function (LOOKUP, VLOOKUP and HLOOKUP) are not case sensitive. For example, if you write a lookup function to look up the text rahim, the function considers any of the following a match: RAHIM, Rahim or RaHiM
Example:
1. Create the sheet given below:
 
The figure below shows a simple example. Range D2:D7 is named Range1, and range E2:E7 is named Range2. The word to be looked up appears in cell B1 (named Value).  … To Read More Click Here to go to Rahim Zulfiqar Ali’s Lesson.

 

 

 

 

You may find Rahim Zulfiqar Ali Google Sites

Que Publishing: “Video Podcasts on VLOOKUP Formulas “

The QUE blog checks in for some mid-week Excel-lence:

“For day three of VLOOKUP Week, this two-part video podcast featuring Bill Jelen demonstrates the VLOOKUP Formulas in Excel. Bill Jelen, author of Excel 2010 In Depth offers a beginning and advanced look at VLOOKUP in these two videos. In video 1, matching data from two lists:! …Click here to continue on to the Videos presented at  Que Publishing Blog.