Forum Discussion
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 adva...
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