# Assign numerical value to cell based on text in another cell

Closed
ERS - Jun 30, 2016 at 10:07 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 30, 2016 at 12:26 PM
Hello,
I'm trying to solve an issue...

Column A cells have a drop down which has 4 text options to choose from:
Tier 1
Tier 2
Tier 3
Tier 4

In Column B cells I'd like to automatically assign a % value associated with those 4 tiers
Tier 1 = 9%
Tier 2= 8%
Tier 3 = 5%
Tier 4 - 3%

Column C will have a manually input \$ value

Column D will multiply B*C to produce a \$ value

Thanks!

## 1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jun 30, 2016 at 12:26 PM
ERS, Good afternoon.

Suppose:
A1 --> Drop Down

At column B you can use a lot of different ways.

a) Using IF Function
B1 --> =IF(A1="Tier 1",9%,IF(A1="Tier 2",8%,IF(A1="Tier 3",5%,3%)))

b) Using VLOOKUP Function
..........F.........G
1.....TIER 1.....9%
2.....TIER 2.....8%
3.....TIER 3.....5%
4.....TIER 4.....3%
B1 --> =VLOOKUP(A1,F1:G4,2,FALSE)

At column C you input VALUE

At column D a Formula

D1 --> =B1*C1

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão