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
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