I am creating a table in excel and need to reference another table. On My data table there are two columns: Column A: Category (About 10-15 Categories) Column B: Page (Every Page is Unique 400+) On Spreadsheet 2 When everever a Category...
I am creating a table in excel and need to reference another table.
On My data table there are two columns:
Column A: Category (About 10-15 Categories)
Column B: Page (Every Page is Unique 400+)
On Spreadsheet 2 When everever a Category is selected i need to return all of the pages associate with it.
ex.
Cat 1 - Page 1
Cat 1 - Page 2
Each category may have 1 - 75 pages within it.
How can i accomplish this? I think i need to use one of the following Offset,Vlookup,Match,Index or a combination. I attached a dummy file.
Thanks in advance to anyone that can help!
Attached Files
Multiple Lookup.xls (62.5 KB)
Linear Mode
