VLookup not finding lookup value

[Betty]

Vlookup is not finding the lookup value in the table array
on a numeric value. The table lookup column is formated
as general. The values were alpha/numeric only and was
working fine. When I added a strictly numeric value, it
is returning a #N/A.

I have tried formatting as text, but it does not help.
The list is sorted in ascending order.

Everything was working in this report until I added the
numeric value to the lookup column.

Example...
DBTYPE_Lookup array
Col.A Col.B
115 Bad returns #N/A
3A Okay returns Okay


Function is...=VLOOKUP(E4,DBTYPE_Lookup,2,FALSE)

Any help will be appreciated.
Thanks,
Betty

 

[Aladin Akyurek]

If the first column of DBTYPE_Lookup is of type text, try...

=VLOOKUP(E4&"",DBTYPE_Lookup,2,0)

where 0 is identical to FALSE in effect.