How to apply vlookup formula in blank cells only <p>I want to apply vlookup formula only in those blank cells B4, B7, B10. I want to write macro so that vlookup formula applies only to the blank cells, rest of the data remain intact. </p> <p><a href="https://i.stack.imgur.com/ecStb.png" rel="nofollow">VLOOKUPFORMULA</a></p>