VLOOKUP Archives

XLOOKUP and XMATCH Function Step by Step Tutorial

July 12, 2020February 15, 2023 PKComments Off

In this article, You will learn how to use XLOOKUP and XMATCH Function in Microsoft Excel. XLOOKUP is very powerful functions. This function is currently available to Microsoft 365 subscribers

VBA

VLOOKUP by cell background color

May 13, 2018April 17, 2023 PK0

VLOOKUP is a popular function in Microsoft Excel. It helps users to find and retrieve specific data from a large table or range of data. However, there is a limitation