How To Use The VlookUp Function | Excel Tutorial
How to Use VLOOKUP in Excel
Introduction to VLOOKUP
- The video introduces the VLOOKUP function in Excel, emphasizing its utility for quickly finding information within large datasets.
- A scenario is presented where a user needs to find revenue data for sales agents, illustrating the importance of VLOOKUP when dealing with extensive lists.
Steps to Use VLOOKUP
- To initiate a lookup, type
=VLOOKUP(followed by the lookup value (e.g., Michael's name in cell C15).
- Select the entire table array containing relevant data and specify the column index number (2 for revenue), indicating which column's data you want returned.
- Choose between approximate match (
TRUE) or exact match (FALSE); an exact match is selected here, returning Michael's revenue of $225,000.
Finding Additional Information
- The process is repeated to find Susan's email; input her name from cell C16 and select the same table array while specifying column 3 for her email address.
- After entering
FALSEfor an exact match, Susan’s email (susan.r@msn.com) is successfully retrieved.
Looking Up Different Data Points
- The tutorial continues with Joseph’s phone number search using similar steps: inputting his name from cell C17 and selecting column 4 for phone numbers.
- Joseph’s phone number (913-412-8593) is displayed as a result of following the established procedure.
Dynamic Adjustments with VLOOKUP
- Once set up, changing names in the lookup formula automatically updates results without needing to retype the entire function. For example, replacing Michael with Lauren shows her revenue ($148,000).
- Similarly, substituting names allows users to retrieve different emails or phone numbers seamlessly.