Convert Excel formula to VBA code

I would like to convert the below formula into a vba code:

=IF(ISNA(VLOOKUP($G8,Lookup!$A$2:$J$831,2,FALSE)),"",VLOOKUP($G8,Lookup!$A$2:$J$831,2,FALSE))

Thanks in advance

Try Application.Evaluate, as in:

Please Login or Register  to view this content.

If you want to use an argument, try:

Please Login or Register  to view this content.

Thanks! I'll give them a try.