Tips & Tricks 203 – Return non-adjacent columns from XLOOKUP

You can use following formula to return non-adjacent columns through XLOOKUP

=XLOOKUP(M2,C:C, FILTER(D:F, {1,0,1}))

=XLOOKUP(M2,C:C, CHOOSECOLS(D:F, 1, 3))

Sample File – T&T_203