Forum Discussion

JET_Home's avatar
JET_Home
Copper Contributor
Dec 24, 2019
Solved

How do I have an address selector in Excel please?

Hi Just set up an invoicing spreadsheet which is formatted exactly as needed! Fallen at the last hurdle though.. I cannot work out how to import the customers name and address into the invoice. Each...
excel
Formulas and Functions
  • PReagan's avatar
    PReagan
    Dec 24, 2019

    Hello JET_Home,

     

    It sounds like your situation requires Data Validation for a drop-down list and VLOOKUP() or INDEX()+MATCH() to pull customer address details.

     

    Can you share a sample workbook (without sensitive information)?

mathetes's avatar
mathetes
Gold Contributor
Dec 24, 2019
Without seeing your workbook it's hard to be certain what the best way is. I have created what might be a similar workbook for my wife's consulting work, and I use VLOOKUP to retrieve the specific addresses, as applicable.

There are other ways, but that's probably the simplest. I am assuming that you have your first page set up as a table (or range with all of those data elements you mention arrayed in a single row per customer

If you need more help, please upload a sample of your workbook (after first removing personal information on customers, etc.)

Resources