Manipulating Date Using Dropdown

L

Les Linton

My workbook has a Main sheet and a Data sheet.

I have a range on the Data sheet A1 to B12.

Column A has a two digit ID number 11, 12, 13....

Column B has a first and last name Bob Jones, Jane Doe, Bill Smith....

I want to create a dropdown list on the main sheet where I select
number from column A "12" and it places the name "Jane Doe" in anothe
cell on the main sheet. "D7"

If this is possible, I would like to add more fields to the range o
table and have those fields filled in on the main sheet.

Thanks,

Le
 
M

Marcelo

Hi,

Data Sheet - select the range A1:A12 - on menu - Insert | Name | Define -
type the name and ADD

Main Sheet - Seletc the cell where you want the drop down C7 as sample - on
menu - Data | Validation | select list and on the box "refers to" type =name.

on cell d7 use =vlookup(c7,DataSheet!a1:b12,2,0)



hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Les Linton" escreveu:
 

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

Bringing to a cell the last date an event occurred 6
vlookup using match and date range 1
finding and deleting cells from one excel sheet to another 5
Finding Info from sheet 1 and removing only those rows from sheet 1
Combine multiple columns and rows for one record into one row. 2
Copy data from one sheet to another 3
Find last row 1
Reference a column to make groups 1

Top