Forum Discussion

excel_safely's avatar
excel_safely
Copper Contributor
Nov 17, 2022
Solved

Excel Formula for matching two columns and referencing a third column

Hi there,  I'm wanting an excel formula that looks at two columns on different spreadsheets and where there is a match, references a different column value as per below:    Tab 1 CARDHOLDER (tab/...
excel
Formulas and Functions
  • dscheikey's avatar
    dscheikey
    Nov 19, 2022

    excel_safely 

    Please try this formula:

    =INDEX(CONTACTS[Role],MATCH(CONTACTS[Combined],CARDHOLDER[FullName],0))

    Alternatively with the more modern XLOOKUP() function:

    =XLOOKUP(CONTACTS[Combined],CARDHOLDER[FullName],CONTACTS[Role])

     

dscheikey's avatar
dscheikey
Bronze Contributor
Nov 19, 2022

excel_safely 

Please try this formula:

=INDEX(CONTACTS[Role],MATCH(CONTACTS[Combined],CARDHOLDER[FullName],0))

Alternatively with the more modern XLOOKUP() function:

=XLOOKUP(CONTACTS[Combined],CARDHOLDER[FullName],CONTACTS[Role])

 

Resources