Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup from one spreadsheet that links to matching keys in another
I have header and detail type information, and would like to use the filter
function on the header spreadsheet then have the spreadsheet link to the detail spreadsheet and just display the rows associated with the data in the filter from the header. Worst case I can combine the two spreadsheets into one via vlookup and just repeat the header information for every detail line but would like to keep the smaller file size associated with holding the data once. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching and Moving Data From One Spreadsheet to Another? | Excel Discussion (Misc queries) | |||
Matching and Moving Data From One Spreadsheet to Another? | Excel Discussion (Misc queries) | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
how do you change pathways (links) when consolidating spreadsheet. | Excel Discussion (Misc queries) | |||
double lookup, nest, or macro? | Excel Worksheet Functions |