| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I return an entire row of data from a reference array?
I have a worksheet of reference information containing rows of data in many
columns that I need to re-use on other worksheets within the same workbook. If I keep one column of data unique, what function can I use to pull back ALL the columns of information for each unique row? I know with VLOOKUP I can pull back one column of data per lookup, but how can I pull back multiple columns? I'm using XP Home. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Coverting array data into single column | Excel Worksheet Functions | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
| Grouping data within intervals | Excel Worksheet Functions | |||
Threaded Mode
