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.

Attached Files

Gains and losses1.xlsx (31.5 KB, 17 views)

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

Absolutely brilliant, thank you I would never have got that in a millions years, does just what I need.

Something like this?

Attached Files

Copy of Gains and losses1.xlsx (48.1 KB, 11 views)