How to Lookup Non-adjacent Columns Using XLOOKUP
How to Dynamically Lookup Non-adjacent Columns
Use a combination of the XLOOKUP & the CHOOSECOLS Functions.
=XLOOKUP(I3,B3:B14,
CHOOSECOLS(C3:G14,
MATCH(J2:L2,C2:G2,0)))
See step by step video & follow for more tips.
#excel #cheatsheets #programming #exceltips