Forum Discussion
Ramon Haagen
Apr 05, 2018Copper Contributor
Which formula to use
Hello,
I am looking for a formula but I don't know which one to use.
What I would like to do is that when in collum material is entered 1804 that it multiplies the collum quantity with 34,3. ...
- Apr 05, 2018=E2*VLOOKUP(D2,$L$5:$M$6,2,FALSE)
JKPieterse
Apr 05, 2018Silver Contributor
=E2*VLOOKUP(D2,$L$5:$M$6,2,FALSE)
Ramon Haagen
Apr 05, 2018Copper Contributor
Works like a charm thanks!