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 L3 to get the same
information. I hope this makes sense.


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