ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to assign values to a cell based on values in another cell? (https://www.excelbanter.com/excel-worksheet-functions/168609-how-assign-values-cell-based-values-another-cell.html)

Joao Lopes

How to assign values to a cell based on values in another cell?
 
I'm trying to figure out a way to automaticcaly assign values to a cell (B3)
based on values typed on cell A3. Example:
A3 values (typed) = 10%, 30%, 50%, 70%, 100%
B3 values (automatically assigned) = min, low, medium, high, max

Tks for the help.



Gord Dibben

How to assign values to a cell based on values in another cell?
 
=LOOKUP(A3,{0.1,0.3,0.5,0.7,1},{"min","low","mediu m","high","max"})

Will you have values that aren't exactly 10, 30, 50, 70 or 100?

If so, how do you want to deal with them?


Gord Dibben MS Excel MVP


On Wed, 5 Dec 2007 11:44:00 -0800, Joao Lopes <Joao
wrote:

I'm trying to figure out a way to automaticcaly assign values to a cell (B3)
based on values typed on cell A3. Example:
A3 values (typed) = 10%, 30%, 50%, 70%, 100%
B3 values (automatically assigned) = min, low, medium, high, max

Tks for the help.




All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com