Help with IF statement

[it's an excel world]

I am looking for the most efficient way to write an if statement in cell E2 that looks in cell D2 for the following.

If left D2,5 = "25201" then "25201"
If left D2,2 = "1B"" then "25201"
If left D2,5 = "25856" then "25856"
If left D2,2 = "RD" then "25856"
If left D2,5 = "25882" then "25882"
If left D2,2 = "RT" then "25882"
Otherwise = "" (blank)

Thanks in advance!!

 

[braindiesel]

Why not use a vlookup instead?

 

[it's an excel world]

That is what I normally do, but I am training someone new on this project and thought it might simplify the process if they performed the VLOOKUP where they just look at the 25201, 25856 & 25882. I really didn't feel comfortable with them filtering the VLOOKUP using the data in column D. There are several dozen unique values that start with 1B, 25201, etc.

 

[Aladin Akyurek]

I am looking for the most efficient way to write an if statement in cell E2 that looks in cell D2 for the following.

If left D2,5 = "25201" then "25201"
If left D2,2 = "1B"" then "25201"
If left D2,5 = "25856" then "25856"
If left D2,2 = "RD" then "25856"
If left D2,5 = "25882" then "25882"
If left D2,2 = "RT" then "25882"
Otherwise = "" (blank)

Thanks in advance!!

Try...

=LOOKUP(REPT("z",255),CHOOSE({1,2,3},
    "",
    VLOOKUP(LEFT(D2,5),{"25201";"25856";25882},1,0),
    VLOOKUP(LEFT(D2,2),{"1B","25201";"RD","25856";"RT","25882"},2,0)))

 

[braindiesel]

=if(or(left(D2,5)="25201",left(D2,2)="1B"),"25201",if(or(left(D2,5)="25856",left(D2,2)="RD"),"25856",If(or(left(D2,5)="25882",left(D2,2)="RT"),"25882","")))

That should do it