VLOOKUP question utilizing the right and left of a given column ineed the mid too dont know how to i

[EP]

=IF(OR(ISNA(VLOOKUP(LEFT(S6,4),DayRTM,2,0)),ISNA(VLOOKUP(RIGHT(S6,4),DayRTM,2,0))),"",VLOOKUP(LEFT(S6,4),DayRTM,2,0)&IF(LEN(S6)>4,"
/ "&VLOOKUP(RIGHT(S6,4),DayRTM,2,0),""))



This formula takes the the value that is typed in cell s6 and looks up
that value in a list called DayRTM and puts the name in the cell t6.


Looks something like this



DayRTM

I-22 Trizna, R
I-32 Bruce, J
I-14 Cook, L




here is the sheet that s6 and t6 are on the above noted formula is in
the T column


S T
6 I-22 Trizna, R
7 I-14 / I-32 Cook, L / Bruce, J


The T column is what the formula pulls from the list DayRTM I Need it to
pull 3 instead of just 2

something like this


S T
6 I-22 / I-32 / I-14 Trizna, R / Bruce, J / Cook, L


Any help would be great

TIA


Edson Peacock

 

[EP]

Thanks to all anyway I figured it out.

Here is the formula in the event anyone is attempting this madness

=IF(OR(ISNA(VLOOKUP(LEFT(E7,4),DayRTM,2,0)),
ISNA(VLOOKUP(MID(E7,8,4),DayRTM,2,0)),ISNA(VLOOKUP(RIGHT(E7,4),DayRTM,2,0))),"",VLOOKUP(LEFT(E7,4),DayRTM,2,0)&IF(LEN(E7)>4,"
/ "&VLOOKUP(MID(E7,8,4),DayRTM,2,0)&IF(LEN(E7)>12," /
"&VLOOKUP(RIGHT(E7,4),DayRTM,2,0),"")))

Thanks

Edson Peacock