Hi all,

I have a problem where I need excel to automatically recognize from the given data on one sheet, the numbers I want to be filled on another sheet.

test excel.xlsx

If you take a look at my example excel: I need the results sheet automatically recognize from the Data sheet "Cars" -> "Volume" -> "Europe"--> numbers next to this (Numbers for the whole year) and to fill these in the right shells on the results sheet.

The reason why I need the excel to recognize these words and the numbers next to them is that the data will be a bit different everytime it is pasted on the data sheet. The columns will be the same but rows might differ.

To make this a bit more complicated this same excel tool Im creating will be used for numerous other products than just cars and boats so locking the formula to always find specifically only these words, will not work. It has to be somehow modified, which product it is used for. Volume, Net Sales and the regional areas will remain the same, although might be in different rows and in different order.

Another issue is that: For example the volume for Europe in P1/10 in the data sheet have to be deducted with the Eurasia's Volume for p1/10 each period to get the right number for Europe's Volume for P1/10 in the Result sheet. (This probably only means putting the formula for europe to be deducted with the formula for eurasia?)

I searched for the solution from many sites and alternative solutions have been INDEX MATCH and vlookup. But the problems/solutions have always been a bit different than what I need and Im not really good with excel to modify them for what I need.

All the help you can give me will be greatly appreciated!

Thanks,
JaakkoLo