I think I am missing something here, but why can't you just test A3

B1: =IF(A3="pippo",value*exchange,"")

where are value ad exchange?

--
__________________________________
HTH

Bob

"Arno" wrote in message
...
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