Trying to build list based on cell value
 

I have a list of states where certain phone services are offered. A row
includes the state name and a select cell that indicates whether the state is
included in a plan. If the cell has a number 1 it is included and if it has
a 0 it is not included.

I would like to build a dynamic list of states included in the plan as the
indicator is flipped from 0 to 1.

Any suggestions? Thank you for your help.

John

Trying to build list based on cell value
 

Learn Dynamic names here


http://www.contextures.com/xlNames01.html#Dynamic

Here you can learn VLOOKUP

http://www.contextures.com/xlFunctions02.html

you could have a 0 or 1 beside the list of states, whatever list you
used for your dropdown menu, the vlookup formula will correspond to it


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537588

Trying to build list based on cell value
 

I'm not following your suggestion Dave, but it could be because I didn't
express my need well enough. Here is an example of the table I have:

State Select
Alabama 1
California 0
Oregon 1
Ohio 1
New Hampshire 0

I would like to create a list on another worksheet that just has those
states that were selected. It would look like:

Alabama
Oregon
Ohio

If your original recommendation will return this type of list, could you
please explain in more detail. I didn't see how at the site that you
originally sent me. Thank you Dave.

John





"davesexcel" wrote:


Learn Dynamic names here


http://www.contextures.com/xlNames01.html#Dynamic

Here you can learn VLOOKUP

http://www.contextures.com/xlFunctions02.html

you could have a 0 or 1 beside the list of states, whatever list you
used for your dropdown menu, the vlookup formula will correspond to it


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537588

Trying to build list based on cell value
 

will the 1 or 0 be in column a or b??


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537588

Trying to build list based on cell value
 

It doesn't matter which column since it's the filtered list that is most
important. Also, because of certain inhouse restrictions, I need to do this
without writing a macro. Thank you again Dave.

"davesexcel" wrote:


will the 1 or 0 be in column a or b??


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537588

Trying to build list based on cell value
 

Oh I see, I was thinking if you entered a state then 1 or 0 would show
up

but if you enter 1 a list of states with the value 1 will apear...



Here is a very similar post from a few months ago, asking for the same
thing, with a detailed explaination from Max,

you could use the autofilter as well...


http://tinyurl.com/ovyf3


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537588