Maybe the issue is on the mix of data types that you have here (numeric and
text). For numeric the lookup value goes as is, for text it has to be
wrapped in quotes:
=VLOOKUP(-5,$A$1:$D$14,2,FALSE)
=VLOOKUP("L3",$A$1:$D$14,2,FALSE)

Depending on what you want to do, there are ways to overcome this. One easy
is to use one another cell as a reference, instead of a fixed value.
=VLOOKUP(F1,$A$1:$D$14,2,FALSE)
Where F1 may contain either text or numbers

Hope this helps,
Miguel.

"MrSales" wrote:


A B C D
AMAX BMIN BMAX
-04 0.9480 0.1950 0.2600
-06 0.9480 0.2390 0.2650
-08 0.9480 0.2770 0.2970
-3 0.9480 0.3080 0.3280
-4 1.2600 0.3750 0.4140
-5 1.2920 0.4850 0.5050
-6 1.2920 0.5940 0.6140
L04 0.9480 0.1950 0.2600
L06 0.9480 0.2390 0.2650
L08 0.9480 0.2770 0.2970
L3 0.9480 0.3080 0.3280
L4 1.2600 0.3750 0.4140
L5 1.2920 0.4850 0.5050
L6 1.2920 0.5940 0.6140

This is my data base and I want to be able to pull the the
corresponding cell according to the number in column 'A' Traditional
Vlookup isn't working properly for me.

Example: I want to be able to enter -5 in another cell and find the
cell to the right that I'm requesting or I want to be able to enter L3
to get the same corresponding information for that row. I hope this
makes sense.


MrSales
View Public Profile
Send a private message to MrSales
Find all posts by MrSales


--
MrSales
------------------------------------------------------------------------
MrSales's Profile: http://www.excelforum.com/member.php...o&userid=32572
View this thread: http://www.excelforum.com/showthread...hreadid=565639