Excel Lookup function for text

0 votes

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
Dec 13, 2022 in Others by Kithuzzz
• 38,010 points
220 views

1 answer to this question.

0 votes

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)

enter image description here

answered Dec 13, 2022 by narikkadan
• 63,180 points

Related Questions In Others

0 votes
1 answer

Excel trim function is removing spaces in middle of text - this was unexpected (?)

Create a UDF that uses VBA's version ...READ MORE

answered Oct 18, 2022 in Others by narikkadan
• 63,180 points
413 views
0 votes
1 answer

Using standard deviation function in excel for a specific criteria?

Use this: =STDEV(IF((A1:A1000>=-0.5)*(A1:A1000<=0.5),A1:A1000)) Depending on one's version this may ...READ MORE

answered Nov 12, 2022 in Others by narikkadan
• 63,180 points
425 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

What is a covered Index?

A covering index is an index that contains all ...READ MORE

answered Oct 10, 2018 in Database by Frankie
• 9,830 points
536 views
0 votes
0 answers

How to use index in select statement?

Let's imagine I established an index (idx ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
• 38,010 points
236 views
0 votes
1 answer

Excel stock and sales data management

you must attach the event handler each ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,180 points
254 views
0 votes
1 answer

Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 63,180 points
838 views
0 votes
1 answer

Excel function for divide or split number to maximum possible equal parts

The underlying math for this is as ...READ MORE

answered Oct 17, 2022 in Others by narikkadan
• 63,180 points
1,500 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP