Forum Discussion

Nathan0979's avatar
Nathan0979
Copper Contributor
Dec 28, 2023

Find Alias according to a table

Hi community, looking for some suggestion here.

Let say I have a list (D1:E8). I want to fill in the Alias by looking at E2:E7 and A1:B4. How could I get my expected result?

Many thanks in advance. :smile:

 



excel
Excel on Mac
Formulas and Functions

1 Reply

  • djclements's avatar
    djclements
    Bronze Contributor
    Dec 28, 2023

    Nathan0979 In cell F2, try either INDEX/MATCH or XLOOKUP, then copy the formula down:

     

    =INDEX($A$2:$A$4, MATCH(E2, $B$2:$B$4, 0))

     

    - OR -

     

    =XLOOKUP(E2, $B$2:$B$4, $A$2:$A$4)

     

    XLOOKUP Function

Resources