As listed in the Master Workbook (see link at the top of the page), there are functions grouped into categories. This video is a demonstration of the Experience Level 1 – Lookup & Reference functions.
The functions covered in this video lesson are:
ADDRESS – COLUMN — COLUMNS — HLOOKUP – INDEX — INDIRECT
LOOKUP — MATCH — OFFSET – ROW – ROWS – VLOOKUP
Extract of Level 1 – Lookup and Reference Functions from the Master Workbook:
A good follow-up lesson to check out would be either the Advanced Vlookup Examples or Advanced Lookup – Index & Match lessons.
Pingback: A Complete Introduction to Excel | MBAx.me
Fairly new to Excell and LOVE your videos, thank you!! I have several folders in Contacts in Outlook 2010, which the program exports into separate Excell .csv files. I have combined them into 1 file with several sheets. Now I want to add a sheet called RECONCILED that I paste the Undeliverable emails into. Then I want to 1. find and erase all those entries. Then 2. Add email addys and then see if I already have them. Can you help me?
Pingback: A Complete Introduction to Excel | MBAx.me
Im having the wesdiert problem and do not know how to solve this. Say you have a competition between 3 persons and you want the Vlookup to pinpoint a specifik name that has the highest score to insert it in a cell named and the winner is -> (next cell contains name).. Ive been twisting the =if and =Vlookup but cant figure it out.. It sounds EXTREMLY simple, but for the love of god, I cant solve it..
Hey Ben,
Offering some really great stuff here- massively appreciated.
Downloaded the master workbook there a cpl days ago and am trying to follow along with this tutorial video at the mo. Has the pivot table sheet been changed since the making of the vid or am I missing something??
Many thanks.
Hey Colm,
Good catch, thanks a lot! Fixed it and updated the file.
Some feedback – I think its important to talk in more detail about how the INDEX-MATCH combination can be used as a more powerful version of VLOOKUP, including the ability to look up columns to the left of the table array, which is one of the limitations of VLOOKUP. It is vital to anyone using large sheets of data that would otherwise have to be constantly rearranged to get the VLOOKUPs to work. Apart from that, a great video!
Thanks for the feedback Ollie!
I certainly agree that the INDEX / MATCH (and INDIRECT) combinations are extremely powerful. I’ll make sure to do an advanced lookup video going through some of the more complex usages of the lookup/info related functions.
EDIT: I’ve posted an advanced lookup video on index & match here.
Than kyou!