Hello,

I've spent several hours searching for a solution and couldn't quite find the answer.

My workbook has two worksheets, the Invoice Template and the Customer Data.

On the Invoice Template, there is a drop-down used to select the customer. When a customer is selected, I have an INDEX MATCH formula to populate the address information into the cells below. This works fine, except if the customer doesn't have any data in the "Attn" column of the Customer Data worksheet. I can make it blank, but what I would really like is for the blank cell to either be ignored and filled with the next cell, or deleted and cells shift up (automatically when the customer is selected).

Please let me know if you need any additional information.

Thanks!
Invoice Test.xlsm