Help to use index and match across Spreadsheets

Iron Contributor

Hi,

 

I have a large data set so in order to keep it simple i have seperated some parts of the spreadsheet. I have one spreadsheet which will contain a large number of tabs for each individual product. For example the 3 stocks from Asset cards, into "historical prices" tab, highlighted yellow.

 

I wish to be able to import the relevant data from the tabs to another spreadsheet, can someone please assist.

 

As example I have the stocks information in "Asset Cards" spreadsheet. I wish to have this "close" price data linked to the a summary tab in spreadsheet "Scenario Analysis".

 

Can someone please assist.

0 Replies