Hi JJK, you can handle this with XLOOKUP by combining the lookup columns into one array. For example, if your data is in rows 2:1000, you could use:
=XLOOKUP(lookup_value,TOCOL(E2:M1000,1),TOCOL(N2:N1000,,1))
However, there is an important detail here: TOCOL(E2:M1000) creates a list...
