I've created the following formula on a worksheet that works properly but
when I try to record a macro to create the formula in visual basic editor it
doesn't would. I get an error "unable to record". Can anyone help me with
this?

=IF(ISERROR(IF(ISERROR(VLOOKUP(TRIM(A2),Sheet3!A:D ,4,FALSE)),VLOOKUP(TRIM(A2),Sheet1!A:C,3,FALSE),(V LOOKUP(TRIM(A2),Sheet3!A:D,4,FALSE)))),"WE
DON'T HAVE A START DATE IN OUR
SYSTEMS",IF(ISERROR(VLOOKUP(TRIM(A2),Sheet3!A:D,4, FALSE)),VLOOKUP(TRIM(A2),Sheet1!A:C,3,FALSE),VLOOK UP(TRIM(A2),Sheet3!A:D,4,FALSE)))
--
Regards,

timmulla