formula, if

[Karine]

I'd like help coming up with a formula that will say if B4=QC , then show"QC
Required" in cell B5. I came up with if(B5="QC",C5) C5 would have "QC
required" in it. This formula works for the first option but how would i go
about have all 5 options listen so if cell1 contains "qc" it would equal "QC
required", BUT if it contain
SC" it would say "step check all welds"... and so forth for L,M,H

QC QC required
SC Step check all welds
L Cycle in auto once if manually operated
M Cycle in auto three times without faults
H Cycle in auto five times without faults

Any help would be great.
Thanks in advance

 

[Pete_UK]

Suppose you put this table out of the way somewhere in the same sheet,
say occupying cells X1 to Y5. Then all you need to put in B5 is this
formula:

=VLOOKUP(B4,$X$1:$Y$5,2,0)

Hope this helps.

Pete

 

[Bob Phillips]

=LOOKUP(B4,{"H","L","M","QC","SC"},
{"Cycle in auto five times without faults","Cycle in auto once if manually
operated","Cycle in auto three times without faults","QC required","Step
check all welds"})

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)