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 62 views

## 1 answer to this question.

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)
``` • 53,160 points

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

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

## 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

## Excel 365 Formulas - How to save LAMBDA function permanently (for all existing and new files)?

Try creating a template for excel to ...READ MORE

## What is a covered Index?

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

## How to use index in select statement?

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

## Excel stock and sales data management

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