All articles with 'xmatch' Tag
{ 146 Comments }
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]](https://chandoo.org/wp/wp-content/uploads/2010/06/range-lookup-excel.png)
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 »{ 61 Comments }
What is XLOOKUP? 13 formula examples to really understand it
Published on Mar 17, 2021 in Excel Howtos

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 »