unction Lookup in a function IF



I have a question on Excel. 


How to put the function Lookup in a function IF (as a “logical test” data). The formula is not very easy.


If this = this (D2=”L1″), find the number associated to this word in the list and multiply it by another number (C2), if not multiply this by this(F2*H2).




I don’t exactly where to put the C2, 


I would be so grateful if somebody could help me. Thank you

By: alfred

Leave a Reply

Your email address will not be published. Required fields are marked *