Auto populate cell
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.
--
Kevin Backmann
"Shek5150" wrote:
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
|