Greetings from France,
I would appreciate it if you could have a look at the following formula and tell me what is wrong as I get a message indicating that there is an error in the formula
=IF(ISNA(VLOOKUP(B3;COMPANY2;15;TRUE));"";VLOOKUP
(B3;COMPANY2;15;TRUE))
IN FACT I AM USING A FRENCH VERSION OF EXCEL AND THE ORIGINAL FORMULA IS
=SI(ESTNA(RECHERCHEV(B3;COMPANY2;15;VRAI));"";RECHERCHEV
(B3;COMPANY2;15;VRAI))
Thank you for your help and best regards from Paris,
Christophe
I would appreciate it if you could have a look at the following formula and tell me what is wrong as I get a message indicating that there is an error in the formula
=IF(ISNA(VLOOKUP(B3;COMPANY2;15;TRUE));"";VLOOKUP
(B3;COMPANY2;15;TRUE))
IN FACT I AM USING A FRENCH VERSION OF EXCEL AND THE ORIGINAL FORMULA IS
=SI(ESTNA(RECHERCHEV(B3;COMPANY2;15;VRAI));"";RECHERCHEV
(B3;COMPANY2;15;VRAI))
Thank you for your help and best regards from Paris,
Christophe