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’.
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
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
1. Create the sheet given below:
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
Check out this entry from Colin Legg: “Binary Searches With VLOOKUP”
“I went for a job interview about a year ago and the interviewer made a passing comment that he didn’t understand why anyone would ever pass TRUE into VLOOKUP’s range_lookup parameter. There are lots of cases when you might want to do this so I thought a few, nice examples would be a great way to get VLOOKUP week underway.” To Read More Click Here to go to Colin Legg’s Lesson.
PLEASE NOTE that Colin will continue to contribute Excel-lent articles this week for VLOOKUP WEEK 2012! Be sure to check them out at Colin Legg on WordPress
To find more from Colin, visit his blog Colin Legg on WordPress