Excel Lookups

[paulmorton]

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.

[NBVC]

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

[paulmorton]

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

[ArviLaanemets]

Something like this?