I'am a newbee in using vba/excel and got this problem.
Can anyone help ?

This is what I'm trying to do
Type a name in a cell"A2" in sheet1 , if name exist in sheet3 "An"
then
sheet1 "C2" is filled with value of "sheet3" "Cn"

If the name do not exist in sheet3 then I want to call a Macro to
put the name in sheet3 first.
( "A2" is filled with #N/A )
I've used this formula and it works but I do not know how to call a
macro.


=IF(ISNA(VLOOKUP(Name;"sheet3";6;FALSE));"not-present";VLOOKUP
(Name;"Sheet3";6;FALSE))