Excel Help - Pick from list

UnworthyBean · 16 May 2013 at 10:56

Hopefully someone who knows a bit about excel will be able to help me out here.

I have a spreadsheet with various headings - Lets say Red Shirts and Blue Shirts and then various names underneath them. I'd like a main spreadsheet that I can pick from a list of Blue and Red, Then it would show me all the names relating to this. Is this possible in Excel?

I know my way around Access and this is simple, But this needs to work on Macs too which don't have Access to Access (see what I did there? :rolleyes:

)

MrZen · 16 May 2013 at 11:09

I Slightly understand what you want, can you explain abit clearer?

so i know exactly what you want

UnworthyBean · 16 May 2013 at 11:15

https://docs.google.com/spreadsheet/ccc?key=0Aljf3hJZmCQBdGV3aWMzNEp5cTJCU21mdzZZRlpMdkE&usp=sharing

A very crude example there.

Data is in columns C,D,E and in column A i'd like to be able to pick from a drop down box of Yellow, Red and Blue and then underneath it would show the corresponding data.

Trying to get thoughts from my head into words is difficult!

gillywibble · 16 May 2013 at 11:27

Why don't you just filter the data?

Egon · 16 May 2013 at 11:29

Is this as simple as it sounds? If so it's just a data validation technique. Give a name to a range of cells, then add data validation to look up the list from that range.

stevengerrard88 · 16 May 2013 at 23:41

How many rows / columns are you going to have?

If not too many, you could use data validation in A1, to give the option of Yellow/Red/Blue.

Then in A2 and downwards, you could use an nested IF statement something like :-

=IF($A$1="Yellow",C2,IF($A$1="Red",D2,IF($A$1="Blue",E2,"")))