VLOOKUP Help

M

MrSales

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 th
corresponding cell according to the number in column 'A' Traditiona
Vlookup isn't working properly for me.

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


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

Excelenator

Have a look at this file. Vlookup works fine.

5116


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 th
corresponding cell according to the number in column 'A' Traditiona
Vlookup isn't working properly for me.

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


MrSales
View Public Profile
Send a private message to MrSales
Find all posts by MrSale
Click to expand...

+-------------------------------------------------------------------
|Filename: Vlookup.zip
|Download: http://www.excelforum.com/attachment.php?postid=5116
+-------------------------------------------------------------------
 
T

Toppers

What is your VLOOKUP formula? The table and VLOOKUP work for me.

Lookup value in E2

=VLOOKUP(E2,$A$2:$D$15,4,FALSE)

This returns value in Column D

HTH
 
M

Miguel Zapico

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.
 
Top