I am trying to auto add a site address by selecting the site name from a drop down menu.
G garr1095 Nov 2, 2006 #1 I am trying to auto add a site address by selecting the site name from a drop down menu.
M Max Nov 2, 2006 #2 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
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
