Prev: Format 8.3568 into: 8 years, 4 months, 8 days, 10 hours, 45 minute
Next: Linking graphs to other spreadsheets
From: Leigh Anne on 11 Feb 2010 11:03
Can Excel 2003 recognize a name in a call in one workbook and then auto
populate the cells from the original worksheet by name recognition?
From: Dave Peterson on 11 Feb 2010 12:44
Not quite automatic...
But you can use a table on that second sheet and a formula...
Create a new table (A1:Bx, say) on a different sheet.
Give the first column (A1:Ax) a nice name.
Use Data|Validation to create a dropdown list with those options as the choice.
Use a formula in the adjacent cell to retrieve the value in the adjacent column
in the table.
Debra Dalgleish has some notes about naming the range:
And for using =vlookup():
http://www.contextures.com/xlFunctions02.html (for =vlookup())
Leigh Anne wrote:
> Can Excel 2003 recognize a name in a call in one workbook and then auto
> populate the cells from the original worksheet by name recognition?
> Leigh Anne