looking in to the 9th and 10th number to give back an output data

[Tartesos]

Im using this formula:

=LOOKUP(REPT("z",255), CHOOSE({1,2,3,4,5,6,7,8,9},"",
VLOOKUP(MID(B424,9,1)+0,configuration!$L$3:$M$22,2,0),
VLOOKUP(MID(B424,9,1),configuration!$L$3:$M$22,2,0)))

What this formulas does for me is to look into the 9th value of a number and depending on that it will give back an input data to the correct cell.
This work great and there is no problem with it.
The problem is that now I need to look the 8th and the 9th to determinate that output data. Ther is any way I can change this formula to do just that? To look a number and depending on the 8th and 9th character it will give you an output ... can this be done ?? Any help will be great.

Thanks

 

[barry houdini]

8th and 9th or 9th and 10th?

For the former try

=LOOKUP(REPT("z",255), CHOOSE({1,2,3},"",
VLOOKUP(MID(B424,8,2)+0,configuration!$L$3:$M$22,2,0),
VLOOKUP(MID(B424,8,2),configuration!$L$3:$M$22,2,0)))

If it's the latter then change the two 8s to 9s

 

[Tartesos]

Thanks, that works, but I also need the formula to look only on the 8th number. Can I put two formulas on one cell? One will look for the 8th and the other for the 8th and 9th.
Is this possible?

Regards,