another vlookup question thanks

[lars]

=IF(ISERROR(VLOOKUP(A3,new327,12,0)),"",VLOOKUP(A3,new327,12,0))

It works some of the time - this is what it's looking up in column A and whether it works or not

3203A - Works for this 5 digit number
D209 - Works for this 4 digit number
5205 - Doesn't work
7205 - Doesn't work
G203 - Works

why does it work for some and not for others?

Thanks

[Aladin Akyurek]

On 2002-03-29 09:21, lars wrote:
=IF(ISERROR(VLOOKUP(A3,new327,12,0)),"",VLOOKUP(A3,new327,12,0))

It works some of the time - this is what it's looking up in column A and whether it works or not

3203A - Works for this 5 digit number
D209 - Works for this 4 digit number
5205 - Doesn't work
7205 - Doesn't work
G203 - Works

why does it work for some and not for others?

Thanks

Lars,

The data type of a lookup value must be the same as that of the same value in the first column of the lookup table.

If the first column of your lookup table is text formatted, you can try to see what you get:

=IF(COUNTIF(the-first-column-range-of-new327,IF(ISNUMBER(A3),A3&"",A3)),VLOOKUP(IF(ISNUMBER(A3),A3&"",A3),new327,12,0),"")

Aladin

PS. ISERROR a function that catches all types of errors known to Excel, therefore not 'informative'.