Adding another true_value to an IF Formula

[Eduards]

Hello all,
Im trying to add another true_value onto this following formula:

=IF(OR(RIGHT(A2,5)={"396OL","400OL"}),"101OL",RIGHT(A2,5))

I have attached a sample workbook. On the left side is my current formula and on the right will be result I'd like to achieve.

My current formula will do the following
396OL will convert to 101OL
400OL will convert to 101OL
If false then keep the last 5 values from the original code.

But Id like to place in the following true_value:
If 413OL then convert to 103OL NOT 101OL

[Kaper]

Try another IF nested in previous one:

Please Login or Register  to view this content.

[Glenn Kennedy]

One way... in G2:

=IF(F2="","",IFERROR(LOOKUP(RIGHT(F2,5),{"396OL","400OL","413OL"},{"101OL","101OL","103OL"}),RIGHT(F2,5)))

[Eduards]

Thank you to both of you, much appreciated!

[Kaper]

Glad to hear that, and thanks for marking thread solved and for reputation point