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

Have a look at this file. Vlookup works fine.

5116



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


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

--
Excelenator


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

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


"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

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

Thank you very much. I just need to use exact much. duh

Thanks again.


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