formula for if/then

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

I'm looking for a formula to translate 21 different qualifiers in Column A to
one of 3 desired values in Column B. Example, Column A reads: Red, Blue,
Green, White, Yellow, etc. I need a 1 entered into Column B if Column A is
Red or Blue, a 2 entered into Column B if Column A is Green or White, etc.
Any suggestions? Thanks!
 
Use a VLOOKUP() Table. In C1 thru D8:

Red 1
Blue 1
Green 2
White 2
Orange 3
Periwinkle 4
Mauve 4
Taupe 5

adjust and extend to meet your needs. Enter the colors in column A and in
B1, enter:

=VLOOKUP(A1,$C$1:$D$8,2,FALSE) and copy down
 
Back
Top