Use following formula for this
=XLOOKUP(M2,C:C, CHOOSE({2,1}, D:D, F:F))
=XLOOKUP(M2,C:C, CHOOSECOLS(D:F,3, 1))
Sample File – T&T_204
Use following formula for this
=XLOOKUP(M2,C:C, CHOOSE({2,1}, D:D, F:F))
=XLOOKUP(M2,C:C, CHOOSECOLS(D:F,3, 1))
Sample File – T&T_204