Tag Archives: MS Excel

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


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


Ute Simon: “Currency Conversion Excel 2010 with VLOOKUP & Conditional Formatting”

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


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

“VLOOKUP, OFFSET and MATCH in PowerPivot” from Javier Guillén

In this example, Javier is simulating (in PowerPivot) the output achieved through double lookups using VLOOKUP, OFFSET and MATCH.

One of those really great functions in the native Excel environment is OFFSET.  In combination with other functions like MATCH, it can generate a type of ‘double lookup’ that can be really helpful when creating dynamic reports.  For example, the table below describes a matrix defining a coordinate of units for each combination of ‘Band’ and ‘Group’. …To Read More Click Here to go to Javier Guillén’s Lesson

You may find Javier on Twitter @javiguillen or at his blog Javier Guillén on WordPress


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.

 


From The MS Office Blog: “VLOOKUP Tutorial: Updating prices in a master product list”

From Emily Warn at Microsoft Excel Blog:

“In honor of VLOOKUP Week, MVP Bill Jelen has created a VLOOKUP tutorial for those of you who have a basic working knowledge of Excel but want to improve your skills. You most likely know the core set of formulas that come with Excel and have heard that VLOOKUP is an easy way to look up a value in an Excel workbook, speeding up getting work done. But that’s about it.”… Click here to continue at Blogs.Office.Com

 


Follow

Get every new post delivered to your Inbox.

Join 53 other followers