Index Match in multiple tabs

[rmadagsen]

I have an excel file for production units of panels tabulated and is still being populated as additional new panel tab is added in every few weeks. For now i have already 6 tabs with each unique tab name and each tab with unique serial series for panel names under Column B and weight kg under Column F. (all tabs with the same format columns A to F) and with a master tab for final approved panel. This master tab is incorporating the different serial series for panel names for all 6 tabs under Column B, but in Column Q, I want to incorporate the weight kg from all the 6 tabs with just one formula. Can somebody help with how to do the syntax for index match? or if there is a better simple way

 

[Domenic]

Have a look at the second example in the following link . . .

Lookup a Value Based on a Single Criteria Across Multiple Sheets | xl-central.com

Perform a lookup based on a single criteria across multiple sheets using a formula in Microsoft Excel.

xl-central.com

However, if it doesn't help, I would suggest that you provide an example by using the xl2BB add-in or by simply using the copy/paste method. I would suggest that you post the data for at least two of your unique tabs, along with the data for your master tab showing the expected results. And you only need to post a few rows of sample data, maybe 5 to 10 rows. And, of course, replace any confidential data with fake data.

Hope this helps!