Macro inserting Vlookup issue

Hi there -

I am trying to insert a Vlookup function within a macro. The macro finds all cells in a column without an entry an replaces a vlookup formula in the cell. However, i need the vlookup formula to lookup a cell in the blank cell's row. eg: =vlookup(b"current row",a1:d100,4,false) but i do not know how to make the vlookup only use the cell's current row with a different column. I have tried to embed the row() function but it doesnt seem to work. Any help would be greatly appreciated.

Thanks!

I Guess im not sure how to incorporate that with the find and replace function, as it places the vlookup directly into the spreadsheet. I dont believe the active cell will work to replace the blank cells and pull up the correct row. Im not sure how to go about coding it into VBA or if there is a way to just place the correct formula into the spreadsheet.

Thanks!

The example spreadsheet attached shows what is needed. In worksheet X column I, a find and replace will be done where it will find blank cells and replace them with this function:

VLOOKUP(B10,'Daily Unload'!A2:H17,7,FALSE)

where the "10" in "B10" needs reflects the row of the current cell when the replace is run. Im not sure how this should be coded on the spreadsheet or in the vba code.

I hope this helps!

Thanks for your help!

Here is the attachment for the previous post -