VLOOKUP problem

Giganews Newsgroups
Subject: VLOOKUP problem
Posted by:  Jan Kronsell (kronsell(removebeforesend)@adslhome.dk)
Date: Fri, 14 May 2004

I use this formula

VLOOKUP(VALUE(LEFT(A1,3),Sheet1!A1:B10=,2,FALSE)

I the first column in the matrix i have fx '345 that is the number as a
textstring. In the lookup cell (A1) i have 34567 and everything works ok.

But if in the matrix I have '002 and in the lookup cell '002222 I get at
N/A. Even if the number in the cells are typed as text, it is treated as
numbers. I can see that VALUE(LEFT(A1,3) returns 2, not 002 as expected. Is
the anyway to solve this?

Jan

Replies