 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / July 2006VLOOKUP 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,  SignatureMrSales 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, > I'm trying to use VLOOKUP to find the corresponding cells to a > particular dash number. [quoted text clipped - 8 lines] > > Thank You, Sorry! Hit the send by mistake, > With the lookup values in A1. B1, C1 you would need to use HLOOKUP > =HLOOKUP(A5,A1:E2,2,FALSE) [quoted text clipped - 12 lines] >> >> Thank You, 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. SignatureMrSales 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. > I'm trying to use VLOOKUP to find the corresponding cells to a > particular dash number. [quoted text clipped - 8 lines] > > Thank You, |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.