Automatically select from a list based on other cell?

scotsbigpaul

New Member
Joined
Oct 13, 2011
Messages
3
Hi
How can I use the value of one cell to automatically pick the value, from a list, in another cell?
Sorry if this is a bit of a basic question. I'm a bit of a novice and struggling to find the answer to this in any other threads.
Cheers
Paul
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Hi T
Thanks for that. Had looked at VLOOKUP and although I'm no expert at it, I didn't think it would work because I'm not looking up the 'Leftmost' column.

I'm looking at say, Cell X2 and if this is Y then I want to automatically pick a specific answer from a designated 'List' of answers in several related cells on that same row?

I'm I getting it wrong? Can VLOOKUP help here or do I need to do something else?
Cheers
Paul
 
Upvote 0
Hi T
Thanks for that. Had looked at VLOOKUP and although I'm no expert at it, I didn't think it would work because I'm not looking up the 'Leftmost' column.

I'm looking at say, Cell X2 and if this is Y then I want to automatically pick a specific answer from a designated 'List' of answers in several related cells on that same row?

I'm I getting it wrong? Can VLOOKUP help here or do I need to do something else?
Cheers
Paul
Be more specific.

When you say "pick", does that mean you want to select something from a drop down menu (list)?

What cells do you want to "pick" from?

Do you need help in populating these "pick lists" ?
 
Upvote 0
Hi Biff
Sorry.
All cells are 'drop-down list cells'.

So cell X2 has a drop-down list of Yes or No.
Cells Y2,Z2,AA2,AB2 etc have other drop-down lists, each column having different drop-down list values except for one shared value e.g 'Not Recorded'.

So if X2 has a value of 'No'. How can I make all the other cells in Row 2 select 'Not-Recorded' from the various Drop-Down lists?

Really appreciate your help!
Cheers
Paul
 
Last edited:
Upvote 0
Hi Biff
Sorry.
All cells are 'drop-down list cells'.

So cell X2 has a drop-down list of Yes or No.
Cells Y2,Z2,AA2,AB2 etc have other drop-down lists, each column having different drop-down list values except for one shared value e.g 'Not Recorded'.

So if X2 has a value of 'No'. How can I make all the other cells in Row 2 select 'Not-Recorded' from the various Drop-Down lists?

Really appreciate your help!
Cheers
Paul
Sounds like you want dependent lists...

http://contextures.com/xlDataVal02.html
 
Upvote 0

Forum statistics

Threads
1,224,416
Messages
6,178,505
Members
452,853
Latest member
philipnjk64

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