Insert formula in all the rows based on other row data

[ssj]

Hello All

I have a formula, need to insert a in the all the rows in column, based the coulm b (till the last row the data exists in colum B)




Please help


Formula is


=IF(ISERROR(VLOOKUP(B2,$A$2:$A$4,1,0)),"No", "Yes")

 

[jarjarbingie]

try:

=IF(B2="","",IF(ISERROR(VLOOKUP(B2,$A$2:$A$4,1,0)),"No", "Yes"))

 

[ssj]

Hello


i am not able to insert this formula by macro in the


Range ("M5").formula = "=IF(ISERROR(VLOOKUP(B2,$A$2:$A$4,1,0)),"No", "Yes")"