How to populate a table based on the cell location of given datas?

[EllenS]

Hi,

I'm a new intern and my boss has given me an excel table to fill in. I know how to do it manually but given the amount of data, using excel functions would be a more appropriate and accurate method. I tried researching how to use the functions but the information overflow isn't helping. Can anyone help me solve this issue or at least guide me towards what exact functions I should be learning to use?

I have attached here a sample of what I need to do, so please take a look at the excel file.
I am using Excel 2010.

So what I have is pretty much a table with information regarding sales by people categorized my Quarter 1 (Q1), Q2 and Q3. Each sales then is classified as Type 1, 2 and 3. All I need done is to place the sales on its equivalent place on the next table.

For example, please look at the yellow number. Smith's Q1 sales of 45987 is a Type 2. Now that number is located on cell C4, how can I use a function to have that same number placed on its equivalent place on the next table in cell I4?

Is easy to simply copy and paste, but each spreadsheet has over 700 entries...Besides my boss would like to in the future be able to update a few entries, so if using functions I believe that if a number is updated, so will it be at all equivalent cells right?

I am really feeling lost... And would appreciate any help!

Thanks alot