K
Khalil handal
Hi,
column J has dates (days of each month). Column K has numbers. the whole
rang is J7:K38.
E12 has a date and F12 has a number.
In cell G12, I need to:
=F12*K? (that has the corresponding date as in cell E12)
ie. if E12 has date 14/10/07 then look for the same date in range J7:J39 and
take the corresponding number in range K7:K39 and multiply it with the value
in f12 and put the answer in cell G12. All in the same s
Khalil]
Hope to have an answer!!
column J has dates (days of each month). Column K has numbers. the whole
rang is J7:K38.
E12 has a date and F12 has a number.
In cell G12, I need to:
=F12*K? (that has the corresponding date as in cell E12)
ie. if E12 has date 14/10/07 then look for the same date in range J7:J39 and
take the corresponding number in range K7:K39 and multiply it with the value
in f12 and put the answer in cell G12. All in the same s
Khalil]
Hope to have an answer!!