Easily adding multiple addresses into invoices

**pinkpearl8130** · 01-03-2009, 03:47 AM

I'm sorry if this question has already been answered, I tried looking for it in the forums and I'm sorry if I missed it.

I have an invoice spreadsheet template that I use to bill multiple customers. I'd like to know the easiest way to plug in a specific customer and address into the "To" field of the invoice from a pre-made list of customer addresses. I read about drop down lists which looks promising but I could not understand how to do it. Would this be the easiest way? Or would linking it from an address list in sheet2 to the invoice that is sheet1 be easier?

**dominicb** · 01-03-2009, 07:45 AM

Good morning pinkpearl8130

...and welcome to the forum!!

Originally Posted by pinkpearl8130

I'd like to know the easiest way to plug in a specific customer and address into the "To" field of the invoice from a pre-made list of customer addresses. I read about drop down lists which looks promising but I could not understand how to do it.

If you want to you a dropdown type box, the easiest way is to use Data > Validation, select list from the Allow settings and then select the range you'd like to use. You then need to use VLOOKUP formulae to pull the correct address from a predefined list.

All that probably sounds a bit too confusing, so here's a simple example to pick apart and see how it hangs together.

HTH

DominicB