Lookup with Mid ???

[GBL]

Hi:
Been trying with no joy:
LOOKUP(VALUE(MID(C4,2,1)),$J$3:$M$10,$K$3:$K$10)
Cell C4 is formatted as text and equal to "123"
Am trying in the above example to extract "2" to make the Lookup work.

Also tried:
LOOKUP(MID(C4,2,1),$J$3:$M$10,$K$3:$K$10)
with no joy.

But LOOKUP(C4,$J$3:$M$10,$K$3:$K$10)
does work if cell C4 is changed to "2".

Any help greatly appreciated.

 

[GBL]

Thanks for the quick reply!

I'll check it; but tell me: - Was your answer relative to Lookup(Array) or
to Lookup(Vector) form? I get the two mixed up so will check out their
difference also.


This works for me
=LOOKUP(VALUE(MID(C4,2,1)),$J$3:$J$10,$K$3:$K$10)

check your $J$3:$M$10