TWO COLUMN Lookup in Excel with the XLOOKUP Function

How to do a two column lookup in Excel using the XLOOKUP function. Learn ALL the best functions in Excel https://amzn.to/3Rg87Go In this example, we need a two column match with XLOOKUP to return a price that is dependent upon the room booked and if lunch is included. This two column lookup is often referred to as a two criteria lookup and the XLOOKUP function makes this easy. Create multiple column lookup formulas with the same technique. Find more great free tutorials at; https://www.computergaga.com Case sensitive XLOOKUP formula https://youtu.be/dbPs73OkY5U More great XLOOKUP function examples https://youtu.be/sTj3KnbGFhM Learn more advanced Excel tricks https://bit.ly/3CGCm3M