Using XLOOKUP with Multiple Criteria

In this video, we will go through an example where there are multiple lookup fields (criteria) where the objective is to return a single value based on the multiple fields.

[@jayarajmarydasan4242]

Need lessons on xlookup to return 2nd value ignoring 1st

[@chandramohan1418]

what to do if to return multiple records.i think FILTER function to be used in that case.

[@macrordinary]

Absolutely. If you need to return multiple records, then you need to use a filter function. However; XLOOKUP can be used to return multiple columns if your return array is more than one column.