#1
|
|||
|
|||
Excel Lookups
I have two workbooks, one is called "Monthly" and is a table of data split by depot, month and business type, the other called By Depot is a single table that I would like to populate depending on what depot I select from a dropdown box.
What formula could I use that would allow me to change the depot in the drop down box and that would change the data accordingly. I have tried a VLOOKUP & MATCH but can't get it to work properly. I have attached my file. Any assistance really would be appreciated. |
#2
|
||||
|
||||
Try:
=INDEX(Table3[[Apr-17]:[Grand Total]],MATCH($B$6,Table3[[Column2]:[Column2]],0)+ROWS(C$10:C10)-1,COLUMNS($C10:C10)) copied down and across the table |
#3
|
|||
|
|||
Absolutely brilliant, thank you I would never have got that in a millions years, does just what I need.
|
#4
|
|||
|
|||
Something like this?
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Maybe I need help with "Lookups"? | garry05 | Excel | 3 | 02-10-2024 01:13 AM |
Word & Excel 2010 - Best Options To Auto Insert MySQL & Excel Data? | Hoser | Word | 1 | 03-17-2017 03:47 PM |
LOOKUP - Complex lookup with 2 lookups in 1 cell | sglandon | Excel | 6 | 05-05-2016 09:44 AM |
[Excel 2007] Building Power Point Slides from data in an Excel Table | bremen22 | Excel Programming | 1 | 08-07-2013 11:01 AM |
Excel 2011 can't open old Excel 98 or Excel X files | FLJohnson | Excel | 8 | 05-09-2012 11:26 PM |