LOOKUP trouble

[MarcelNZ]

I am using the following formula but get N/A error
=LOOKUP(LEFT($F17,1),$J$6:$J$13,K$6:K$13)
formatting is set to general through entire sheet
what am I doing wrong?
appreciate your help
marce

 

[Claus Busch]

Hi Marcel,

Am Fri, 5 Apr 2013 09:18:40 +0000 schrieb MarcelNZ:

I am using the following formula but get N/A error
=LOOKUP(LEFT($F17,1),$J$6:$J$13,K$6:K$13)
formatting is set to general through entire sheet
what am I doing wrong?

if Left($F17,1) is numeric then try:
=LOOKUP(--LEFT($F17,1),$J$6:$J$13,$K$6:$K$13)


Regards
Claus Busch