question

[makisgr]

does anyone knows if i can multiply two cells by using the VLOOKUP i
one cell ?for example : E4(95862) * C20(20%) = F4(19172)

thank

 

[Don Guillett]

Have you tried ?

=e4*c20

 

[makisgr]

the first thing i've done! what i want to find out is if i can
multiply two cells somehow not by using the MMULT command but by using
the VLOOKUP command

 

[Don Guillett]

It sounds like you need to give a complete explanation of what you are
trying to do.

 

[RWN]

Do you mean multiplying the results of multiple Vlookups?
As in, for ex, Vlookup(A2,Table1,2,False) * Vlookup(B2,Table2,3,False).
i.e.. Find the 2nd element in table 1 that matches the key A2 and
multiply it by the 3rd element in table 2 using the key in B2.
If so, then yes you can.
If not, then you'll need to be more specific.