There are many amazing things you can do with XLOOKUP, and I have covered some in the video below: It can scan the list, find out the position of the lookup value, and return the value from any corresponding column in the same row. When you identify an item you would want to order, you look to the right to check the prices.Īnd that’s what XLOOKUP does for you.

so you get their menu and start scanning the menu from top to bottom. If you’re still confused about what this function does, consider this – you go to a newly opened café close to your house and you want to eat something. It also allows you to find the value, and then return any other value from the same row or column. You can use this function in situations where you need to scan a list of values in rows or columns and find out if the list contains the value you’re looking for (called the lookup value). XLOOKUP is a refined version of VLOOKUP, that addresses some of the drawbacks that VLOOKUP has. This means people using the earlier versions of Excel won’t be able to use it. It is a new function that is available in Excel 2021 and Excel for Microsoft 365. XLOOKUP is the king of advanced functions (Microsoft hasn’t given this title to any function, but I am sure no one deserves it more than this function). FIND / SEARCH Function (With Wildcard Characters).SUMIF/COUNTIF & SUMIFS/COUNTIFS Functions.

Advanced excel 2021