What If or conditional formatting?

  • Thread starter Thread starter Avicayia
  • Start date Start date
A

Avicayia

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?
 
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
 
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 'Shits'
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
 
Back
Top