Excel formula help

[Homerboy]

I have a sheet (DATA) with the following data layout:

CODE	Oldest	> 5 Days Behind	-5	-4	-3	-2	-1	TODAY	1	2	3	4	5	6	7	8	9	10	11	12	13	14	>=14 Days Ahead	TOTAL	USER
98	01/01/2011	21496	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	21496	49
95	01/01/2010	12014	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	12016	49
90	01/10/2011	2312	0	2	0	0	0	0	0	0	0	0	1	1	0	1	1	0	0	0	0	0	8	2326	49
91	01/01/2011	1540	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	17	1559	49
300	05/23/2011	710	0	7	6	2	3	5	0	0	5	13	5	7	4	0	0	9	6	4	9	4	161	960	36
161	01/06/2011	694	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	694	49
98	01/01/2011	690	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	690	33
98	01/01/2008	666	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	666	16
300	05/06/2011	651	0	7	3	4	9	8	0	0	6	5	8	2	7	0	0	8	7	4	6	5	194	934	38
300	06/08/2011	640	0	1	5	6	7	3	0	0	6	6	7	8	5	0	0	3	3	3	4	9	196	912	40

On another sheet (REPORT) I have 2 cells that need referenced:

AB3 and C7

What I need is a formula that will give me the value for the "4" column value in the table above, when the CODE column = C7 and the USER column = AB3 (I can then subsequently apply this data for all the columns for "-5" "-4", "-3" "-2" etc)

So, for example,
C7 = 300
and
AB3 = 36
then my value for the "4" column is 13

Does that make sense?
I'm familiar with INDEX, VLOOKUP etc, but just can't wrap my head around this double-cell match.
Any help would be greatly appreciated.

 

[GuitarDaddy]

In your data sheet create a new column and use the concatonate function to join the code column with the user column ie "30036" "30038" "30040" etc.

On your other sheet do the same with the C7 and AB3 fields.

Then its just a matter of doing a vlookup of the concatonated field on the second sheet to the concatonated field on the data sheet

 

[Homerboy]

In your data sheet create a new column and use the concatonate function to join the code column with the user column ie "30036" "30038" "30040" etc.

On your other sheet do the same with the C7 and AB3 fields.

Then its just a matter of doing a vlookup of the concatonated field on the second sheet to the concatonated field on the data sheet

Hmmm that's so evil it just may work. nice thinking outside the box

There is an issue though....
Obviously C3 extends to C4, C5 etc etc.
as I get to the bottom of the C column in "REPORT", the fields aren't single digit. The are ranges or multiple CODES.

For example C12's value is "709,712" and C15 is "450-461"

I assumed I was going to have to do some SUMs for those rows.