Input data to a table using 2 variables

[Legacy 188153]

I have a table that is going to be receiving values but I don't know how to calculate where to input the data.
I couldn't upload via attachment so here is the link to fully understand the table I'm talking about - http://img841.imageshack.us/img841/3606/imagevu.png
The departments are identified on the upside and the months of the year on the left.

What is needed to know in order to calculate where the input will be:
Identification of month (probably using the function TODAY to keep it updated, I don't know how to do this)
AND
Department (which is already identified in cell D4 of Sheet1)

The information to input is at cell F8 in Sheet 1.

 

[Legacy 188153]

Is this too confusing or not even possible?

 

[Legacy 188153]

Anyone?

 

[Legacy 188153]

Hellooooo

*echoooo*

*echooo*

*echoo*

*echo*

 

[Legacy 188153]

BUMP, I guess...

 

[Norie]

You really need to give more information, preferably in words.

There's no data in the image, we don't know what you want to calculate, don't know what data you currently have etc.

 

[Legacy 188153]

Not to be rude but, I said exactly what I needed...

I don't know how to calculate where to input the data

As for what data the table will receive, I thought that it wouldn't matter much since I added the information about where the values were located.

The values that will go into the table are numbers. More specifically, a sum done by calculating X numbers.
The values in the table will then be used to calculate internet bandwidth consumption averages for each department on each month.

There are 2 variables to know where to input the data and they are:
1) Let's call it MONTH. Which is the identification of current month. (which refers to the rows of the table)
This can be a number or a text string, I just need to match it to the rows of the table to know where the data I have, should go.
2) Let's call it DEPARTMENT. Text string. Which is the identification of the department. (which refers to the columns of the table)
This is already identified and the text string is at cell D4 of Sheet1.

2 more variables.
DATA - the data that needs to go into the table, it's a number. It's located at cell F8 of Sheet1.
LOCATION - the where to put DATA.

Conclusion:
I think it should be a match between the variable MONTH with the months of the table and the variable DEPARTMENT with the departments of the table to find out the variable LOCATION. After we know the variable LOCATION, we copy the value DATA to LOCATION.
I'm not sure if this is or not a good way to do this.

If there's anything at all that I can explain better please let me know.

 

[Norie]

That's a much clearer explanation.

You can use the MATCH worksheet function.

 

[Legacy 188153]

My apologies for the long absence on this topic.

Could you be more specific on how to use the MATCH function?
I've tried it when I was "playing around" with VLOOKUPs but I have no knowledge whatsoever on how to effectively use it for this.

 

[Legacy 188153]

Bump.