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)