fbpx

All articles with 'xlookup' Tag

Image Lookup – How-to show dynamic picture in a cell [Excel Trick]

Published on Dec 16, 2020 in Learn Excel
Image Lookup – How-to show dynamic picture in a cell [Excel Trick]

Do you ever want to have an image or picture lookup in Excel? Something like the depiction above.

In this article, learn how to set up an image lookup using Excel. You can use this to display staff details, product images or machine parts etc.

Continue »

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 »