I've googled around for the answer on this and the solutions I've found have been unsatisfactory or too specific to be of much help in my case, so hopefully this will help explain correctly what I need to do.

I need to reflect a units number from my internal database table within an ad campaign report in another table, so I can see what my cost per acquisition is.

The table with my units number looks like this:

	A	B	C
1	Date	Source	Units
2	1/1/07	CBS	 45 
3	1/2/07	CBS	 68 
4	1/3/07	CBS	 76 
5	1/4/07	CBS	 99 
6	1/5/07	CBS	 17 
7	1/1/07	NBC	 8 
8	1/2/07	NBC	 62 
9	1/3/07	NBC	 16 
10	1/4/07	NBC	 72 
11	1/5/07	NBC	 87 
12	1/1/07	ABC	 16 
13	1/2/07	ABC	 25 
14	1/3/07	ABC	 29 
15	1/4/07	ABC	 41 
16	1/5/07	ABC	 47
and my other table, my campaign report looks like this:

	A	B	C	D	 E	 F
1	Date	Source	Imps	Clicks	 Cost	 Units
2	1/2/07	CBS	200000	650	 $1,000 	
3	1/4/07	NBC	500000	1150	 $2,500 	
4	1/5/07	ABC	80000	245	 $400
I added column F to the second table to reflect number of units from the first table.

I want to put a formula in column F where it will look up the two variables within the same (campaign report) table, Date and Source, then go to my internal database table, look up the line that has the match for the same date/source, and pull the appropriate units number into the campaign table. So in my campaign table, column F2 would pull the number 68 from the internal table because there's a match on both "1/2/07" and "CBS"; columns F3 would pull 72, and column F4 would pull 47.

Of course, I want to replicate this function between two tables with tens of thousands of rows!

Can anybody help me with this? I really appreciate it if you can.

Chuck