M
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
one cell ?for example : E4(95862) * C20(20%) = F4(19172)
thank
D
Don Guillett
Have you tried ?
=e4*c20
=e4*c20
M
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
what i want to find out is if i canmultiply two cells somehow not by using the MMULT command but by using
the VLOOKUP command
D
Don Guillett
It sounds like you need to give a complete explanation of what you are
trying to do.
trying to do.
R
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.
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.