Auto Populate & Name Recognition

L

Leigh Anne

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

Dave Peterson

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.

=if(a1="","",vlookup(a1,sheet2!a1:bx,2,false))

Debra Dalgleish has some notes about naming the range:
http://contextures.com/xlDataVal01.html#Name

And for using =vlookup():
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://contextures.com/xlFunctions02.html#Trouble
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Speech Recognition & Dictation in Excel: How to turn it on? 0
auto update to multiple worksheets 2
How do I auto populate based on a drop down list? 0
Worksheet Tab index 10
Auto populate a cell based off a look up table 2
Auto Populate 1
Auto-populate other cells based on dates 2
Auto fill not working 2

Top