Hello

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).

=IF(D2=”word”,(VLOOKUP(E2,G4:G18,K4:18,True)*C2),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