If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
What If or conditional formatting?
I am trying to create a spread sheet for company shirt orders. I don't know
if this is possible, but I hope that it is. I have two cells. In the first cell I have a list of available shirts that a person can choose from. What I am looking to do is, when an individual selects a shirt, I want the adjacent cell to generate a list of available shirt colors based on the "Shirt" selection. Is this possible? |
#2
|
|||
|
|||
What If or conditional formatting?
Take a look at this:
http://www.contextures.com/xlDataVal02.html -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Avicayia" wrote: I am trying to create a spread sheet for company shirt orders. I don't know if this is possible, but I hope that it is. I have two cells. In the first cell I have a list of available shirts that a person can choose from. What I am looking to do is, when an individual selects a shirt, I want the adjacent cell to generate a list of available shirt colors based on the "Shirt" selection. Is this possible? |
#3
|
|||
|
|||
What If or conditional formatting?
Hi,
I'm assuming in the one cell with the available shirst you have a Data Validation list set up. In another part of the spreadsheet create al ookup table something like the following: Column G Column H ( wherever you want to put your lookup table) button down red, white, blue polo green, yellow dress orange, blue, purple In the adjacent cell to the avaialble shirts type: =vlookup(a1,g1:h3,2) Hopefully this will give waht you want. If this helps, please press Yes. John "Avicayia" wrote: I am trying to create a spread sheet for company shirt orders. I don't know if this is possible, but I hope that it is. I have two cells. In the first cell I have a list of available shirts that a person can choose from. What I am looking to do is, when an individual selects a shirt, I want the adjacent cell to generate a list of available shirt colors based on the "Shirt" selection. Is this possible? |
#4
|
|||
|
|||
What If or conditional formatting?
Somewhere in the workbook I have this table.
For this demo let this be in F1:J5 Shirts Colours A B C A tan red tan white B tartan green tartan navy C blue&white blue blue&white black white black The range under the text 'Shirts' has the name '****s' and the range under 'Colours' is named 'Colours' Let A1 be the cell where the use selects a shirt type (A, B or C) This is done with Data Validation using the list "Shirts" The formula in G2 (the cell under 'Colours' in =INDEX(H2:J2,MATCH($A$1,$H$1:$J$1,0)) This is copied down the column When A1 changes the list of colours changes The cell where the colour is chosen uses Data Validation with the list Colours Email me directly (get my email addy fro my website) and I can send you a sample file best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Avicayia" wrote in message ... I am trying to create a spread sheet for company shirt orders. I don't know if this is possible, but I hope that it is. I have two cells. In the first cell I have a list of available shirts that a person can choose from. What I am looking to do is, when an individual selects a shirt, I want the adjacent cell to generate a list of available shirt colors based on the "Shirt" selection. Is this possible? |
#5
|
|||
|
|||
What If or conditional formatting?
Unfortunately the formatting of my posting did not come out good. In column
G are listed the different shirt types and in Clolumn H are the colors associated with them. John "Avicayia" wrote: I am trying to create a spread sheet for company shirt orders. I don't know if this is possible, but I hope that it is. I have two cells. In the first cell I have a list of available shirts that a person can choose from. What I am looking to do is, when an individual selects a shirt, I want the adjacent cell to generate a list of available shirt colors based on the "Shirt" selection. Is this possible? |
Thread Tools | |
Display Modes | |
|
|