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