Invoice address query

**NBVC** · 02-11-2009, 09:56 AM

you need to name the Name range...first

Select the range containing the names and go to Insert|Name|Define

Enter a name...e.g. "Names" without quotes.

And enter the range in the source field.

Now go to the cell you want to put the drop down in and go to Data|Validation.. select List from the Allow choices.

enter =Names

in the address field.. enter formula: =Vlookup(A1,Sheet2!A1:B100,2,FALSE)

where A1 is the drop down cell containing chosen name... Sheet2!A1:B100 contains the list of Names and corresponding addressess...

Revise references to suit your data

**BongoBill** · 02-11-2009, 10:11 AM

When I try the Insert tab I can't find Name?

**Dunc3142** · 02-11-2009, 10:56 AM

Hope this helps.

**BongoBill** · 02-11-2009, 11:21 AM

Thanx Dunc3142, I've got that bit sussed and defined all the columns it's the vlookup bit I'm struggling with.

I understand the "Vlookup(A1,Sheet2!" bit of NBVC's post, it's the bit after....

I assume the A1:B100 bit refers to the addresses range but not understanding the 2,FALSE bit

Keeps returning #N/A