VBA - Paste formula If

[mtietz]

I have a formula I want to paste into every BLANK cell in column H

The formula is as follows
=IF(B11>0,INDEX(REPORT!A:B,MATCH(CONCATENATE("Char #",B11),REPORT!A:A,0)+1,2),"")

I do not want it to overwrite cells in column H if something already exists

 

[Fluff]

Duplicate to: VBA help - probably easy to answer

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.