fbpx

All articles with 'xmatch' Tag

Range Lookup in Excel – How to lookup the pricing tier? [Formulas]

Published on Dec 17, 2022 in Learn Excel
Range Lookup in Excel – How to lookup the pricing tier? [Formulas]

Excel formula to get a match from a given value in excel when you have start and end values in lookup table. This technique is useful for looking up a matching price from a pricing tier table or date in a range of start and end dates.

Continue »

What is XLOOKUP? 13 formula examples to really understand it

Published on Mar 17, 2021 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 »