Hi Can anyone help me here plsI need to check this value H47 in columns L & W and return corresponding value from column K or V (whichever applies). Thanks

=LET(a, XLOOKUP(G47, E6:E41, L6:L41), b, XLOOKUP(G47, P6:P41, W6:W41), IF(a>b, XLOOKUP(G47, E6:E41, K6:K41), XLOOKUP(G47, P6:P41, V6:V41)) or =LET(a, XMATCH(G47, E6:E41), b, XMATCH(G47, P6:P41), IF(INDEX(L6:L41, a)>INDEX(W6:W41, b), INDEX(K6:K41, a), INDEX(V6:V41, b))

Join us June 17–18 for a deep dive into Copilot Control System—live expert-led sessions and Q&A on data security, agent lifecycle, adoption, and more! Learn more >

Forum Discussion

SP3990

Copper Contributor

May 29, 2025

lookup value in multiple column and return

Hi Can anyone help me here pls

I need to check this value H47 in columns L & W and return corresponding value from column K or V (whichever applies). Thanks

excel

Formulas and Functions

1 Reply

HansVogelaar
MVP
May 29, 2025
=LET(a, XLOOKUP(G47, E6:E41, L6:L41), b, XLOOKUP(G47, P6:P41, W6:W41), IF(a>b, XLOOKUP(G47, E6:E41, K6:K41), XLOOKUP(G47, P6:P41, V6:V41))

or

=LET(a, XMATCH(G47, E6:E41), b, XMATCH(G47, P6:P41), IF(INDEX(L6:L41, a)>INDEX(W6:W41, b), INDEX(K6:K41, a), INDEX(V6:V41, b))