Purpose of this Excel Infographics for XLOOKUP
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 XLOOKUP quickly.
What is XLOOKUP
Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.
The Syntax of XLOOKUP
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])
- To see it in action, create this list of fruits in range A1:C5.
- Enter this in B7 =XLOOKUP(A7,A2:A5, C2:C5)
- In English it means search cell A7 in the Fruit column and tell me the Quality of the Fruit.
- The VLOOKUP equivalent is =VLOOKUP(A7,A2:C5, 3, False)
- Challenge: How to you change this formula to get the Amount AND Quality for a Fruit?
- Ans: =XLOOKUP(A7,A2:A5,B2:C5)
Why bother learning XLOOKUP?
Like VLOOKUP, XLOOKUP allows you to instantly search a large worksheet to find information. It is the modern and flexible replacement for older functions like VLOOKUP, HLOOKUP, and LOOKUP. The XLOOKUP Function is only available to Office 365 users onwards, Office 2019 and earlier versions users will not get XLOOKUP.
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.