Vlookup Formula

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

 

[Bernard Liengme]

=VLOOKUP(E12,J7:K38,2,FALSE)*F12
if you indent to copy the formula down the column
=VLOOKUP(E12,$E$7:$K$38,2,FALSE)*F12
best wishes

 

[RAGdyer]

Does your range end at Row 38 or 39?

Anyway, try this in G12:

=F12*LOOKUP(E12,J7:K38)

*IF* Column J is in chronological order.

If not, try this:

=F12*VLOOKUP(E12,J7:K38,2,0)

Format G12 to General or Number.

 

[Khalil Handal]

Hi,
used this formula: F12*VLOOKUP(E12,$J$7:$K$38,2,0)
it worked well even when copying down the colomn
Thanks

Does your range end at Row 38 or 39?

Anyway, try this in G12:

=F12*LOOKUP(E12,J7:K38)

*IF* Column J is in chronological order.

If not, try this:

=F12*VLOOKUP(E12,J7:K38,2,0)

Format G12 to General or Number.
--
HTH,

RD

----------------------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
----------------------------------------------------------------------------------------

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

 

[RAGdyer]

You're welcome, and thanks for the feed-back.
--
HTH,

RD

----------------------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
----------------------------------------------------------------------------------------

Hi,
used this formula: F12*VLOOKUP(E12,$J$7:$K$38,2,0)
it worked well even when copying down the colomn
Thanks

Does your range end at Row 38 or 39?

Anyway, try this in G12:

=F12*LOOKUP(E12,J7:K38)

*IF* Column J is in chronological order.

If not, try this:

=F12*VLOOKUP(E12,J7:K38,2,0)

Format G12 to General or Number.
--
HTH,

RD

----------------------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
----------------------------------------------------------------------------------------

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