Purpose of this Excel Infographics for VLOOKUP
Infographics (information + graphics) use visuals and text to highlight key information and ideas. The overall goal of infographic creation is to convey complex information in a simplified and in a compact manner. Using this teaching format, we can learn Excel formula like VLOOKUP quickly.
What is VLOOKUP
VLOOKUP is one of the most powerful formula of MS-Excel when you need to find things in a huge table. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID. Typically we will store a few lists of information on a worksheet and use VLOOKUP function search for something specific within a range of cells much like looking up for a word in a dictionary.
How to use VLOOKUP (The Syntax of VLOOKUP)
=VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
- To see it in action, create this list of fruits in range A1:C5.
- Enter this in B7 =VLOOKUP(A7,A2:C5, 3, False)
- In English it means search cell A7 in the Fruit column and tell me the Quality of the Fruit.
- Challenge: How to you change this formula to get the Amount for a Fruit?
Why bother learning VLOOKUP?
VLOOKUP allows you to instantly search a large worksheet to find information without any computer programming! It is one of the must know Excel formula for any data analyst.
What’s next after VLOOKUP?
Try other information searching Excel functions like HLOOKUP, XLOOKUP, MATCH & INDEX.
Need more help?
To learn more about Excel functions, enroll for our Excel Training Courses in Singapore. Aeternus Consulting features the best excel courses in Singapore conducted by expert consultants from basic Excel to Analyst levels. We have a complete learning road map for Microsoft Excel to advance your career.