Okay this is what I have:
(Sheet 1)
A1-A5 = names (range is named "Name")
B1-B5 = id # for each name (range is named "ID")
(sheet 2)
A1= a drop down list that you can choose from the "Name" list on Sheet 1
What I would like:
for B2 on Sheet to automatically fill in the correct "ID" that goes with the "Name" for Sheet 1.
I know this can be simple, but I can't remember how to do it. Any suggestions? Thanks in Advance!!
Bookmarks