Hello experts,

I need a help. I have a Excel file, where I write a brief for my customers. In the cell H3, I select the name (using Dropdown List). The cells A2, A3 and A4 will find (through VLOOKUP from Sheet2) the name, address, ZIP Code and State. Until here, okay.

The problem is that some customers have a function that I need to write in the next row after the name. For Example:

John Smith
355 W Rancho Santa Fe
85323 – Avondale


Or

David Gross
Head of IT
33501 So 25th East
83406 - Ammon Idaho Falls

I don’t want to leave an empty line between name and address. How can I make an IF, when the column B from sheet2 is not empty? So, if column B is not empty, than the 2 rows after the name should be dragged one row below, so this “empty” row can be filled with the function (another VLOOKUP).

Here is an example from my Excel:

https://www.dropbox.com/s/kc82hdzy1a...rief.xlsx?dl=0

Thanks for the help!

Jacare