Cell VLookup formula converted to VBA. I need help converting this Code

[Dustin R]

I am having a hard time figuring out how to convert my VLookup formula I have in my cells to a VBA format. Here is the code that I have in my Cells and I need to convert to VBA form.
=IF(ISNA(VLOOKUP($C4&" "&U$3,LMSDTU,18,FALSE)),"",VLOOKUP($C4&" "&U$3,LMSDTU,18,FALSE))
Your help is greatly appreciated.

 

[Osvaldo Palmeiro]

Try:

ActiveCell = "=IF(ISNA(VLOOKUP($C4&"" ""&U$3,LMSDTU,18,FALSE)),"""",VLOOKUP($C4&"" ""&U$3,LMSDTU,18,FALSE))"

 

[igold]

See if this does what you want...

Range("A1").Formula = "=IF(ISNA(VLOOKUP($C4&"" ""&U$3,LMSDTU,18,FALSE)),"""",VLOOKUP($C4&"" ""&U$3,LMSDTU,18,FALSE))"