IF function to get a (specific) name from a Vlookup and convert va

A

Arno

A3 (Vlookup) returns a name, depending on which name I need the if function
in a cell to multiply the value by the exchange rate - USD to EURO

Problem
A3 contains a Vlookup and it does not return the name that I need to
establish if the formula can or cannot convert the value from USD into EURO

Example:
A3=pippo
B1 if A3="pippo",B1*0.78 ...instead I get 0 or FALSE....

Can anybody assist - Thanks Arno
 
G

galimi

Arno,

You need to fill in the false aspect of your tertiery function.

=If(A3="pippo",true,false)

You left out the false part
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link an IF to a Vlooup 5
Link an IF formula with a cell containing a Vlookup formula 4
Convert A1 value to a sheet name and copy to it 2
IF and Vlookup? 3
Combining If, Vlookup in formula 2
Convert a range of numbers to strings 2
Excel Trying to do a vlookup with a nested right function on the array 3
Combining IF Statement and Vlookup 0

Top