Drop down list that gets 3 cells

R

richiwatts

Board Regular
Joined
Aug 27, 2002
Messages
131
I have a list on sheet 2 with 3 columns

Column A = ID
Column B = Name
Column C = Age

On sheet 1 I need to select the ID from a drop down list.

ID is in column A
Name is column D
Age is H

Is there a way that once I select the ID from the drop down list (list created from sheet) that I can automatically populate Name and Age in the correct columns/cells?

I hope this is understandable

Rich
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Sort by date Sort by votes
sounds like a simple lookup table - or if the id's cannot be in ascending order, an offset match approach would work

are you familiar with these ?
 
Upvote 0
id12name39id1name17
id2name19
id3name21
id4name23this table called mytable
id5name25
enter an id in A1id6name27
id7name29
id8name31
name39 obtained byid9name33
=VLOOKUP(A1,mytable,2)id10name35
id11name37
id12name39
id13name41
id14name43
id15name45
id16name47
id17name49
id18name51
id19name53
id3name55enter an id in A20id20name55
name 55 obtained by
=OFFSET($J$27,MATCH(A20,$J$28:$J$47,0),1)
id4name17
id5name19
id6name21
id7name23
id8name25
id9name27
id10name29
id11name31
id12name33
id13name35
id14name37
id15name39
id16name41
id17name43
id18name45
id19name47
id20name49
id1name51
id2name53
id3name55

<colgroup><col width="64" span="15" style="width:48pt"> </colgroup><tbody>
</tbody>
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question
Dependent Drop Down Help, Excel 2010
Replies
5
Views
90
Akuini
Akuini
S
  • Solved
Question about Drop down list
Replies
3
Views
182
RoryA
RoryA
I
  • Question
data validation list inside google site or make it online
Replies
0
Views
156
INN
I
J
  • Solved
Auto-populate cell if data validation list has only one option
Replies
7
Views
191
Jeffrey Mahoney
Jeffrey Mahoney
I
  • Solved
Type in field to jump to first instance of what was typed from a drop down list
2 3 4
Replies
38
Views
825
ipbr21054
I

Forum statistics

Threads
1,214,411
Messages
6,119,346
Members
448,888
Latest member
Arle8907

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top