Vlookup based on cell having data

[backyardfun]

I have a sheet (attached) in which data will be entered in columns A-G. And H is a vlookup value which will be locked and users will not be able to edit. This is a running sheet with several users and since I don't want to monitor this on a daily basis and don't want to copy/paste the vlookup formula into hundreds of empty lines to stay out in front of it, I want column H to populate with the Vlookup formula ONLY when there is a value entered in column G of that same row. In addition and separately, when a value is typed in column A, I want it to put ALL BORDERS on the next row (columns A-H). Thanks.

[boninm]

Here's one solution. Do an If condition

=IFNA(VLOOKUP(G6,Sheet2!A:B,2,FALSE),"")

[PCI]

In sheet1 module code put next code

Please Login or Register  to view this content.

[sintek]

Please Login or Register  to view this content.

[backyardfun]

This worked great but I forgot one thing. I added 3 more columns (I, J, & K) and I also need the formula populated in column Kx: (Ix-Jx)/Ix in which x is the current row #. Thanks.

[PCI]

See next code

Please Login or Register  to view this content.

[PCI]

Another one a bit nicer from sintek's code

Please Login or Register  to view this content.

[sintek]

Please Login or Register  to view this content.

[HansDouwe]

I also need the formula populated in column Kx: (Ix-Jx)/Ix

Please try in K2 and copy down:

Please Login or Register  to view this content.