| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF function to get a (specific) name from a Vlookup and convert va
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Searching specific record using VLOOKUP function. | Excel Worksheet Functions | |||
| How do I convert a specific date to a fiscal quarter ? | Excel Discussion (Misc queries) | |||
| convert to specific format | Excel Discussion (Misc queries) | |||
| Convert specific text to a corresponding number | Excel Discussion (Misc queries) | |||
| Macro to convert specific Numbers to Letters... | Excel Programming | |||
Threaded Mode
