ExcelBanter - LOOKUP trouble

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - LOOKUP trouble (https://www.excelbanter.com/excel-worksheet-functions/448545-lookup-trouble.html)

MarcelNZ

LOOKUP trouble

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

Spencer101

Quote:

Originally Posted by MarcelNZ (Post 1610933)

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?

Claus Busch

LOOKUP trouble

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

All times are GMT +1. The time now is 09:04 PM.