Xlookup formula will only look up values in one column not two

I have a formula that I use to look up a seat number in one tab of a work book and if it is there it returns the name of the person that seat is assigned to in a different tab. The formula I have b...

excel

Formulas and Functions

m_tarler
Aug 13, 2024
or maybe:
=XLOOKUP(G2,RSVP!$I:$I,RSVP!$A:$A, XLOOKUP(G2,RSVP!$J:$J,RSVP!$A:$A,""))
alternatively you could use wildcard option unless G2 could be a subset and you don't want that:
=XLOOKUP("*"&G2&"*",RSVP!$I:$I&RSVP!$J:$J,RSVP!$A:$A,"",2)

Detlef_Lewin

Silver Contributor

Aug 13, 2024

Lhelgert

=XLOOKUP(G2,RSVP!$I:$I&RSVP!$J:$J,RSVP!$A:$A,"")

m_tarler

Bronze Contributor

Aug 13, 2024

or maybe:

=XLOOKUP(G2,RSVP!$I:$I,RSVP!$A:$A,
    XLOOKUP(G2,RSVP!$J:$J,RSVP!$A:$A,""))

alternatively you could use wildcard option unless G2 could be a subset and you don't want that:

=XLOOKUP("*"&G2&"*",RSVP!$I:$I&RSVP!$J:$J,RSVP!$A:$A,"",2)

Forum Discussion

Xlookup formula will only look up values in one column not two

Resources