vlookup function help

[hooknows]

Hi,

I think I need help with the vlookup function, but I'm not exactly sure.

Here is what I'm trying to accomplish. Hopefully, someone can help me. I have 4 columns of data.
- Column A has dates
- Column B has % amounts that correspond to Column A
- Column C has another set of dates
- Column D has $ amounts that correspond to Column C


I would like to add another Column, Column F that will do the following:
1) Look at the date in Column A
2) For each date in Column A, take the corresponding % amount in Column B and mulitply it by the $ amount that corresponds to the same date, which is in Column C.

Wow, is that confusing enough?

Please let me know if I can clarify or post additional information.

I greatly appreciate any help.

Jimmy

 

[Aladin Akyurek]

Book7
	A	B	C	D	E	F
1	Date	%	Date	Amt	%xAmt
2	2/20/2004	0.08	2/22/2004	42		#N/A
3	2/21/2004	0.71	2/23/2004	28	19.88
4	2/22/2004	0.53	2/24/2004	74	39.22
5	2/23/2004	0.02	2/25/2004	34	0.68
6	2/24/2004	0.87	2/26/2004	95	82.65
7	2/25/2004	0.95	2/27/2004	24	22.8
8	2/26/2004	0.98	2/28/2004	63	61.74
9	2/27/2004	0.78	2/29/2004	97	75.66
10	2/28/2004	0.56	3/1/2004	55	30.8
11
Sheet1

Formulas...

E2:

=IF(ISNA(F2),"",INDEX($D$2:$D$10,F2)*B2)

F2:

=MATCH(A2,$C$2:$C$10,0)

 

[Zack Barresse]

something like this...

Book6
	A	B	C	D	E	F
1	Date	Percent	Date	Dollar(s)	Formula	Check
2	1/1/2004	50%	5/5/2003	$100.00	$162.50	$162.50
3	5/5/2003	75%	6/1/2003	$500.00	$75.00	$75.00
4	6/10/2003	25%	6/10/2003	$250.00	$62.50	$62.50
5	2/10/2004	100%	1/1/2004	$325.00	$225.00	$225.00
6	6/1/2003	50%	2/10/2004	$225.00	$250.00	$250.00
Sheet1

formula is =
=B2*(VLOOKUP(A2,C$2:D$6,2,0))

 

[hooknows]

Thanks to both of you for the quick replies! I got it!