unction Lookup in a function IF

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

Leave a Reply

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