How To Use Xlookup In Excel Sheet (Get One Output With Two Criteria )

To do this, type =XLOOKUP( in the ribbon bar. The next step is to insert your lookup criteria. This is the data you're looking to search for. While XLOOKUP supports numbers and text strings, most users will want to specify a cell reference (such as A2).