formula for if/then
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
--
Gary''s Student - gsnu200795
"Sue" wrote:
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!
|