| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I return multiple columns from a vlookup?
I have two worksheets each of which has the same unique identifier in the 1st
column. I have manged to get a basic VLOOKUP function working so I understand the concept. Now what I would like to be able to do is return multiple columns of data when the VLOOKUP is successful. Is this possible? -- carolyn |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I return multiple columns from a vlookup?
Carolyn-- you'll need multiple vlookups in subsequent columns to accomplish it. The Col_index_num needs to be upped for each column you are moving over. Hope this helps. Stacie -- SPenney ------------------------------------------------------------------------ SPenney's Profile: http://www.excelforum.com/member.php...fo&userid=1079 View this thread: http://www.excelforum.com/showthread...hreadid=510267 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I return multiple columns from a vlookup?
You can just use multiple =vlookup() formulas.
carolyn wrote: I have two worksheets each of which has the same unique identifier in the 1st column. I have manged to get a basic VLOOKUP function working so I understand the concept. Now what I would like to be able to do is return multiple columns of data when the VLOOKUP is successful. Is this possible? -- carolyn -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I return multiple columns from a vlookup?
Thank you both for your help. I had obviously been staring at this problem
for too long and when you step back and look at it the problem is so simple. Thanks again -- carolyn "Dave Peterson" wrote: You can just use multiple =vlookup() formulas. carolyn wrote: I have two worksheets each of which has the same unique identifier in the 1st column. I have manged to get a basic VLOOKUP function working so I understand the concept. Now what I would like to be able to do is return multiple columns of data when the VLOOKUP is successful. Is this possible? -- carolyn -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table (vlookup 2 column text values, return 1 value) | Excel Discussion (Misc queries) | |||
| Populate multiple columns | Excel Worksheet Functions | |||
| Vlookup return multiple columns | Excel Worksheet Functions | |||
| how do I filter for 1 variable in multiple columns | Excel Worksheet Functions | |||
| Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
Linear Mode
