How do I use a vlookup in VBA

[CJCAMPBELL41]

Here is the Vlookup I am trying to convert to VBA

=IF(ISNA(VLOOKUP(AM2,MSJ_Daily!A:Z,26,FALSE)),"",VLOOKUP(AM2,MSJ_Daily!A:Z,26,FALSE))


Thanks,
Chris

 

[alow]

What is it you want to do with the formula in VBA?