- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2004 May
- VLOOKUP problem

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

- Re: VLOOKUP problem posted by Frank Kabel on Fri, 14 May 2004