fbpx

All articles with 'xlookup' Tag

Top 10 Excel formulas for IT people

Published on Jun 18, 2020 in Learn Excel, Project Management
Top 10 Excel formulas for IT people

Are you in IT & use Excel often? This article explains top 10 formulas for IT professionals. Useful for project managers, IT analysts, Testing people and BAs.

We cover a 10 practical situations and explore various Excel formulas to solve them. Example workbook provides more details too.

Continue »

Lookup last non blank value – Excel Challenge

Published on Jun 12, 2020 in Excel Challenges, Learn Excel
Lookup last non blank value – Excel Challenge

I have a fun Excel lookup challenge for you. You have data as shown below and want to find the last non blank value for a given account number. For example, for acct number 2015, the answer would be Freedom. How would you solve this? Refer to this workbook for 3 possible answers. Just move […]

Continue »

What is XLOOKUP? 13 formula examples to really understand it

Published on Sep 5, 2019 in Excel Howtos
What is XLOOKUP? 13 formula examples to really understand it

Office 365 now boasts a powerful successor to the VLOOKUP function – XLOOKUP formula. Think of XLOOKUP as VLOOKUP 2.0. In this article, learn all about the function, syntax, optional parameters and 13 xlookup examples.

Continue »