Dec 27 2023 10:50 PM
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.
Dec 27 2023 11:18 PM
@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)