How to achieve this.... [formula help, please]

[kryten68]

Hi
Would greatly appreciate some assistance in figuring out how to achieve the following.
I don't doubt that it's probably quite simple to some of you guru's out there.

See image of my data:

That is in a sheet in my workbook named 'data'.

I need to use this data to populate another sheet named 'summary', which is structured thus:

So, as I'm sure you are already realising, I need C2 on that sheet to contain '13', C3 to contain 23 and so on. All the way through to C25 which should contain 215.

The thing is... this is just an example. In my real application I have several thousands of data lines in the 'summary' sheet, so I need the formula(s) that would go in the $C column of the summary sheet to be smart enough (if possible) so that I can drag the formula from C2 to probably around C7000 and it'll grab the values without needing manual editing of the formula - otherwise it will take ages.

I have a number of manipulations coming up that will need this kind of thing done, so I would very much like to learn the proper Excel way to do this kind of thing. There must be an easy way to do this?

Would greatly appreciate any assistance.
Thanks!

 

[davesexcel]

The formula in C2 would be
=INDEX(data!$B$3:$I$5,MATCH(A2,data!$A$3:$A$5,0),MATCH(LEFT(B2,FIND(" ",B2)-1)&RIGHT(B2,LEN(B2)-FIND(" ",B2)),INDEX(data!$B$1:$I$1&data!$B$2:$I$2,0),0))