Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
VLOOKUP Function Excell
Name: ragenow Date: June 17, 2004 at 01:37:25 Pacific OS: win 2k CPU/Ram: 600/128
Comment:
Does anyone know how to make the function VLOOKUP (or a combination of functions) seek out 2 cells of data in an array (or table) before returning a specific collum. Hope this makes sence. Cheers,
Name: Report_2 Date: June 17, 2004 at 04:06:33 Pacific
Reply:
Yes using the CONCATENATE formula.
Right click on the below link (MultiVLookup.xls) and select "Save Target As" to get a copy of an example spreadsheet.
I learned to do what you are wanting to do from the same spreadsheet but I am not able to locate the source of it on the Author's webpage so I have made it available on my own. Author: Aaron Blood and original source http://www.xl-logic.com/
Please let me know once you have a copy of it so I can remove it from my webspace.
Summary: That's going to involve VBA in the form of a UDF (User Definded Function). A User Defined Function is a function that can be used in Excel but which calls some VBA code to determine the final value of...
Summary: I have 2 charts, and want to say if the answer is 1 in the first chart, use the vlookup function to get the answer out of the second chart. Same with if the answer in the first chart is 2. Can I do th...
Summary: I need help with the vlookup functions in excel. Let's say I have two tabs, the second tab is a pivot table based on the first tab. I want to build a vlookup function (probably need two in the same fo...
0 
