replace or substitute multiple values

[StrugglewExcel]

column c
Orange
blue
yellow

Need Column d to translate
Replace orange with 45
replace blue with 65
Replace yellow with 88

whats the easiest function to handle this

[azumi]

maybe

=LOOKUP(C1,{"Orange","Blue","Yellow"},{65,45,88})


or

=CHOOSE(MATCH(C1,{"Orange","Blue","Yellow"},0),45,65,88)


put on D1 and copied down

[Glenn Kennedy]

Hi there. Here's one way:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"orange",45),"blue",65),"yellow",88)