K
Khalil Handal
Range1 is the name of the range d3:AA33 in the sheet "chart". This range
represent 12 months of the year, for each month TWO colomn the first is for
the date and the second has a value (a value for each day of the year).
C7 in sheet3 has a date value.
in (sheet3) I need to have a formula as follows:
take the value for the corresponding date (month and day) in sheet "chart"
that has the same date as in C7 and multiply it with value in cell H7
(sheet3) and put the result in cell I7.
i.e. if c7 = 26/06/07 , vlookup for that date from sheet "chart" take the
value next to it (on the its right in the same line) and multiply it with
the value in cell H7 sheet3 and put the result in cel I7.
Hope it is clear.
represent 12 months of the year, for each month TWO colomn the first is for
the date and the second has a value (a value for each day of the year).
C7 in sheet3 has a date value.
in (sheet3) I need to have a formula as follows:
take the value for the corresponding date (month and day) in sheet "chart"
that has the same date as in C7 and multiply it with value in cell H7
(sheet3) and put the result in cell I7.
i.e. if c7 = 26/06/07 , vlookup for that date from sheet "chart" take the
value next to it (on the its right in the same line) and multiply it with
the value in cell H7 sheet3 and put the result in cel I7.
Hope it is clear.