|
|
|
|
Quote:
Originally Posted by 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
marcel
|
Does =LOOKUP(VALUE(LEFT($F17,1)),$J$6:$J$13,K$6:K$13) do what you need?
|