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!