Forum Discussion
Match a specific cell by an identifying number across multiple sheets
Hello! I'm looking to create a master spreadsheet from multiple tabs in excel. Specifically, I need to pull the total cost from each tab and match to the serial number on the master tab. - Each ...
Please provide a sample worksheet stating your issue. It would be better to see and solve it
Thanks for your response! I have attached a mock report. I am trying to match the serial number in column A on the master tab to the serial numbers in H5 on the individual site tabs, to then take the cost in cell I30 and add it to column D on the master tab.
You already have the location and city in columns B and C. Can we use that, or do you want formulas in those columns too?
If we can use column B, it's simply
=INDIRECT("'"&B2&"'!I30")
in D2, then fill down.
