# vlookup function help

#### hooknows

##### New Member
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

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

##### MrExcel MVP
Book7
ABCDEF
1Date%DateAmt%xAmt
22/20/20040.082/22/200442 #N/A
32/21/20040.712/23/20042819.88
42/22/20040.532/24/20047439.22
52/23/20040.022/25/2004340.68
62/24/20040.872/26/20049582.65
72/25/20040.952/27/20042422.8
82/26/20040.982/28/20046361.74
92/27/20040.782/29/20049775.66
102/28/20040.563/1/20045530.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

##### MrExcel MVP
something like this...
Book6
ABCDEF
1DatePercentDateDollar(s)FormulaCheck
21/1/200450%5/5/2003\$100.00\$162.50\$162.50
35/5/200375%6/1/2003\$500.00\$75.00\$75.00
46/10/200325%6/10/2003\$250.00\$62.50\$62.50
52/10/2004100%1/1/2004\$325.00\$225.00\$225.00
66/1/200350%2/10/2004\$225.00\$250.00\$250.00
Sheet1

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

#### hooknows

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

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,167,951
Messages
5,856,477
Members
431,817
Latest member
db74

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back