Auto populate cell

S

Shek5150

How do I auto populate a cell based upon the value of another cell.

For example, If value in cell A1 is between 1-5, then I'd want the value of
B1 to auto populate w/ a designated text lable of "Mild"...or if the value in
cell A1 was between 6-10, then the value of B1 would auto populate w/ the
designated text lable of "Moderate." Etc...

Thanks in advance for any assistance w/ this issue.

Steve
 
K

Kevin B

Create a lookup table similar to the one below, with the ratings at each
breakpoint value. The example has the table located in range AA1:AB3 of the
same workhseet as your data:

AA AB
1 Moderate
6 Mild
11 Extreme

To return the rating use the following VLOOKUP function:

=VLOOKUP(A1,$AA$1:$AB$3,2,TRUE)

It matches the value in A1 to the values in the table located in $AA$1:$AB$3
and returns the value from column 2 of the table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate row with work days 1
Formula to auto-populate with current date 1
Finding Text within an Array 2
Automate cell 2
Automating cell to transfer to another cell 1
Auto fill cell based upon another cell value 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Populate cell with a value if another cell has a certain value 5

Top