Vlookup? #name

[gtbb]

There is something wrong in my fomular but I cann't figure out what it is? I have spent three days but still get stuck. Could someone help me please?

Thanks so much!!

IF(LEFT(B2,3)=F2,VLOOKUP(LEFT(B2,3),B2:F16,2,FASLE)," ")

 

[Andrew Poulsom]

It's:

IF(LEFT(B2,3)=F2,VLOOKUP(LEFT(B2,3),B2:F16,2,FALSE)," ")

 

[gtbb]

Hi,

Thanks for the quick reponse. I fixed the spelling error, but it now gives me an #N/A error? Any idea why?

 

[barry houdini]

What's in B2, where do you expect to get a match?

 

[gtbb]

B2 contains letters between 3 to 10. The first three letters are unique for each one. So, if I enter three letters in F2, the result would be the relevant number code in colum C.

 

[Andrew Poulsom]

Why are you looking up the first 3 characters of B2 in the range B2:F16, which includes B2? Couldn't you just as easily use =C2?

 

[barry houdini]

Perhaps you want

=IF(ISNA(VLOOKUP(F2&"*",B2:C16,2,FALSE)),"",VLOOKUP(F2&"*",B2:C16,2,FALSE))