How to convert excel formula to VBA?

zabiullakhan · May 5, 2011

i have an excel formula as bellow, i wanna write this formula in VBA.

Code:

=IF(ISERROR(VLOOKUP(AM2,Sheet1!$A:$B,2,0)),"",VLOOKUP(AM2,Sheet1!$A:$B,2,0))

please help.

Tom Urtis · May 5, 2011

When you attempted to do that with the macro recorder, and you tried to run that macro, what was the result?

zabiullakhan · May 5, 2011

Sorry i dont have a macro.. i have just writen this formula in excel just wanna to automate it..