edit my VLOOKUP formula

[tlacloche]

im using the following formula to change the words Forward, Left, Right, and Back into the word "Pass" in a new column.

=VLOOKUP(A1, {"Forward","Pass";"Left","Pass";"Right","Pass";"Back","Pass"},2,0)

However, the other words listed in column A, are converted into N/A errors.
is it possible for my formula to do what i want above but also leave the other words in column A unchanged in the formula column

[Jonmo1]

Try

=IF(OR(A1={"Forward","Left","Right","Back"}),"Pass",A1)

[tlacloche]

silly me, i forgot to mention that i also would like to make the words "fast" and "slow" be changed to "speed"

so all in all:
forward, left, right, and back converted to "pass"
fast and slow converted to "speed"
AND other remaining words stay unchanged.

thanks

[Jonmo1]

ok..

=IF(OR(A1={"Forward","Left","Right","Back"}),"Pass",IF(OR(A1={"Fast","Slow"}),"Speed",A1))

It would probably be easiest to build a lookup table on your sheet somehwere, say G2:H7
G2:G7 = left right forward back fast slow
H2:H7 = pass pass pass pass speed speed

Then use
=IFERROR(VLOOKUP(A1,G2:H7,2,FALSE),A1)

[tlacloche]

used the =IF(OR(A1={"Forward","Left","Right","Back"}),"Pass",IF(OR(A1={"Fast","Slow"}),"Speed",A1))
works perfectly

thanks!!

[Jonmo1]

You're welcome.