How do I fill mutiple cells with one pull down menu?
 

I am trying to auto add a site address by selecting the site name from a drop
down menu.

How do I fill mutiple cells with one pull down menu?
 

You could use either a VLOOKUP or INDEX/MATCH in each of the multiple cells
to lookup that DV cell, and extract the relevant col's info from the source
table housing the site name, address and other fields

Browse Debra's nice coverage on VLOOKUP or INDEX/MATCH at her:
http://www.contextures.com/xlFunctions02.html
VLOOKUP

http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"garr1095" wrote:
I am trying to auto add a site address by selecting the site name from a drop
down menu.