unction Lookup in a function IF

[Tim alfred 343]

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

 

[Hui]

I think you want:
=IF(D2="word",(VLOOKUP(E2,G4:K18,5,True)*C2),F2*H2)

Note how I have rearranged the VLookup function to retrieve the 5th column "K"