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
marcel

Does =LOOKUP(VALUE(LEFT($F17,1)),$J$6:$J$13,K$6:K$13) do what you need?

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2