View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arno Arno is offline
external usenet poster
 
Posts: 60
Default Link an IF to a Vlooup

Hello,

What I need to achive in cell B1 is: if A3 = "pippo" then value*exchange
rate, "", otherwise leave it blank


In A3 there is Vlookup returning a name.
As I said depending on the name I need the if function
in B1 to multiply the value by the exchange rate - USD to EURO

Problem
A3 contains a Vlookup and it does not return the name to the cell B1 that
contains the IF function therefore I am not able to establish if the formula
can or cannot convert the value from USD into EURO -

B1 is returning only true or false but not the name in A3 - The name (pippo)
in B1 is what I need.


Hope you can help - Thank you - Arno