Excel Lookup function for text

Question

Regarding Lookup, I'm totally baffled.

Say I have a list of weapons with their corresponding victory rates, ranging from weapon A to weapon E. Player 1 selected Weapon C in Table 2, and I want the "Weapon Win Rate" column to reflect that choice, which is 30 in Table 1.

I tried using lookup, but it only functions for values; the text is not supported. Would you please let me know if there is a different method I can use to look up text?

Table 1.

Weapon	Win Rate
A	10
B	20
C	30
D	40
E	50

Table 2.

Player	Weapon	Weapon Win Rate
Player1	C
Player2	B
Player3	A
Player4	E
Player5	D

Answer 1

Use a simple VLOOKUP() function like:

=VLOOKUP(E2,$A$2:$B$6,2,FALSE)

You can also use index match in this way:

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

With Microsoft Excel 365 you can use the below formulas:

=XLOOKUP(E2,$A$2:$A$6,$B$2:$B$6)    
=@FILTER($B$2:$B$6,$A$2:$A$6=E2)