Convert Excel formula to VBA code

[Shiva_sss]

Hi,

This is the excel formula that I need in VBA code. Would appreciate if someone could help me convert this formula into a VBA code. Thank you.

=IFNA(VLOOKUP(LEFT(S2,7)&BA2&BE2,'filepath/Workbook/Sheet1'!$D$4:$E$1048576,2,FALSE),IFNA(VLOOKUP(LEFT(S2,7)&BA2&BE2,'filepath/Workbook/Sheet2'!$E$3:$G$1048576,3,FALSE),IF(OR(MID(S2,3,1)="P",
LEFT(S2,3)="RHS"),"Option1","Option2")))

 

[akmatz]

Start by inserting the formula into a cell on a worksheet. (make sure that the formula works; resolves to a solution.)
START the macro recorder.
Press F2 (this puts the cell into Edit mode)
Press enter, this writes the VBA code into the macro recorder.
STOP the macro recorder.
Examine the resulting VBA code that was written with the recorder in the VBA IDE; should contain VBA equivalent of the formula.