Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Help
I'm trying to use VLOOKUP to find the corresponding cells to a particular dash number. Example A1 B1 C1 D1 E1 -3 2 4 X 3 I want to be able to enter -3 in a a cell containing VLOOKUP to get what is in cell C1. It says I have an error in the formula. I have various dash numbers that i'm working with. Is it the (-) that's causing a problem? Thank You, -- MrSales ------------------------------------------------------------------------ MrSales's Profile: http://www.excelforum.com/member.php...o&userid=32572 View this thread: http://www.excelforum.com/showthread...hreadid=564333 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Help
With the lookup values in A1. B1, C1 you would need to use HLOOKUP
=HLOOKUP(A5,A1:E2,2,FALSE) With the values in A1, A2, A3 etc this works, "MrSales" wrote in message ... I'm trying to use VLOOKUP to find the corresponding cells to a particular dash number. Example A1 B1 C1 D1 E1 -3 2 4 X 3 I want to be able to enter -3 in a a cell containing VLOOKUP to get what is in cell C1. It says I have an error in the formula. I have various dash numbers that i'm working with. Is it the (-) that's causing a problem? Thank You, -- MrSales ------------------------------------------------------------------------ MrSales's Profile: http://www.excelforum.com/member.php...o&userid=32572 View this thread: http://www.excelforum.com/showthread...hreadid=564333 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Help
With the values in A1, B1, C1 etc you would need HLOOKUP to find the values
in A2, B2, C2 etc =HLOOKUP(A6,A1:E2,2,FALSE) If that was a typo and you meant the values are in A1, A2, A3 etc then this works to find the values in B1, B2, B3 etc =VLOOKUP(A6,A1:B5,2,FALSE) Regards, Alan. "MrSales" wrote in message ... I'm trying to use VLOOKUP to find the corresponding cells to a particular dash number. Example A1 B1 C1 D1 E1 -3 2 4 X 3 I want to be able to enter -3 in a a cell containing VLOOKUP to get what is in cell C1. It says I have an error in the formula. I have various dash numbers that i'm working with. Is it the (-) that's causing a problem? Thank You, -- MrSales ------------------------------------------------------------------------ MrSales's Profile: http://www.excelforum.com/member.php...o&userid=32572 View this thread: http://www.excelforum.com/showthread...hreadid=564333 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Help
Sorry! Hit the send by mistake,
Alan. "Alan" wrote in message ... With the lookup values in A1. B1, C1 you would need to use HLOOKUP =HLOOKUP(A5,A1:E2,2,FALSE) With the values in A1, A2, A3 etc this works, "MrSales" wrote in message ... I'm trying to use VLOOKUP to find the corresponding cells to a particular dash number. Example A1 B1 C1 D1 E1 -3 2 4 X 3 I want to be able to enter -3 in a a cell containing VLOOKUP to get what is in cell C1. It says I have an error in the formula. I have various dash numbers that i'm working with. Is it the (-) that's causing a problem? Thank You, -- MrSales ------------------------------------------------------------------------ MrSales's Profile: http://www.excelforum.com/member.php...o&userid=32572 View this thread: http://www.excelforum.com/showthread...hreadid=564333 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Help
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |