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.
Пікірлер: 3
@jayarajmarydasan42422 ай бұрын
Need lessons on xlookup to return 2nd value ignoring 1st
@chandramohan14186 ай бұрын
what to do if to return multiple records.i think FILTER function to be used in that case.
@macrordinary6 ай бұрын
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.