Forum Discussion

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
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)?

PReagan

Bronze Contributor

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)?