Two formulas one cell??

[Tartesos]

Hello again,

I need to use two lookup formulas in one cell. One will look on the 9th number or letter and depending on the data in that place will give an output. The other formula will look the 8th and the 9th number and depending on that combination will give the correct output data. How can I do this??

This is one formula that will look for the 9th:

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

This the formula that will look for the 8th and 9th:

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

There is any way I can get them on the same cell so if on the 9th number is found a number of letter will give an output and if it find a number or letter on the 8th and 9th will give other output?
On the L column you can find single numbers or letters and also a combination of two numbers or two letters. The problem is that now I can only use one of this formulas and that means that I can't cover the results I want, any help ??

Regards,

 

[Tartesos]

jasonb with this formula the output data is not what I want.

Ok, let me explain a bit.

On the sheet configuration I have the "L" column and the "M" column.
In "L" you can find single numbers or letters or combination of both like:
0
1
2
3
01
11
21
41
etc..

In the "M" coulmn you can find the output for the "L" column ...
what i need is to get my formula to look on the 9th number and give me the correct output data from "M" but if there is a combination with 01, 11, 21, 41, 51,61,71,81,91 in the 8th and 9th place to look on those two number and not on a single one(9th).
So, look for the 8th and 9th and if any of this combinations is found: 01,11,21,41,51,61,71,81,91 then give the correct output data for this combinations.
In case that those combinations are not found then the formula should give an output result looking only on the 9th place of the ref. number.
Is that a bit more clear??

Regards,

 

[jasonb75]

My bad, had lookups in the wrong order

=LOOKUP(REPT("Z",255),CHOOSE({1,2,3,4,5},"",
VLOOKUP(MID(B5,9,1)+0,configuration!$L$3:$M$31,2,0),
VLOOKUP(MID(B5,9,1),configuration!$L$3:$M$31,2,0),
VLOOKUP(MID(B5,8,2)+0,configuration!$L$3:$M$31,2,0),
VLOOKUP(MID(B5,8,2),configuration!$L$3:$M$31,2,0)))

 

[Tartesos]

Great stuff !! is done ... thanks

regards,