Use Index Match or other function to consolidate values from list with varying references

[vviswanathan]

Hello, I'd like to figure out a formula that will consolidate values of lines belonging to the
same family in table 1(see attached excel sheet) and pull that sum into the respective line in table 2. I will constantly be
adding new names to table 1, inserting rows, etc. so do not want this to throw off the
formula. Can you please advise on a good way to do this? I have a complele list of
Family Names (like those in table 2) which will not change, as well as a complete list
of Account names (Table 1) that also will not change. These sheets are also located in
different workbooks.

Thanks!
Vijay

[oeldere]

with text to column with a space as seperator.

after that a pivot table.

see the attachment.