# Insert formula in all the rows based on other row data

#### ssj

##### New Member
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)

Formula is

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

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
try:

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

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")"

Replies
9
Views
206
Replies
2
Views
128
Replies
4
Views
112
Replies
3
Views
182
Replies
0
Views
119

1,196,308
Messages
6,014,583
Members
441,828
Latest member
cofracr

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back