Vlookup

  • Thread starter Thread starter JohnDK
  • Start date Start date
J

JohnDK

I am having trouble with vlookup.

I specified the reference table, all my arguments seem to be correc
but i keep getting #N/A.

Table looks like this.

Column D Column E
Row 1 4.CSD682S Category A
Row 2 4.FBCAS31 Category B
Row 3 4.CSD932K CAtegory C


Hypothetically in cell A1 the entered value would be "4.CSD682S" , s
in cell B1 I want the returned value "Category A".

My Formula in cell B look like this :

=vlookup(A1,$D$1:$E$3,2,FALSE)

I doesnt work and i keep getting the dreadful #N/A

Can Anybody please advise.

Th
 
Hi
in your example try the following: enter
=A1=D1
does this return TRUE. I would assume it will return FALSE. This would
indicate in your case A1 and D1 are not equal. check for spaces,
invisible characters, etc.
 
Hi Frank.

A1=D1

The spacing & formatting is exactly the same.

There are thousands of different 4. numbers which i want to match wit
a list of about a 100.
All those numbers are extracted from a database, so there is no manua
entering of values which might cause additional spaces & commas.
The list or table contains the 4.numbers exactly as they would appea
in the database and after its been extracted.

I keep getting #N/A regardless of what i try.

Can it be that it wont be recognized because of the "." in the value?

Th
 
Hi
can you mail me an example sheet (only some rows of your data) and I'll
take a look at it?
email: frank[dot]kabel[at]freenet[dot]de

I'll look at it tomorrow morning - Time to stop working now :-)
 
Back
Top