ramseysearcy
New Member
- Joined
- May 11, 2016
- Messages
- 2
DOORSTYLE | LANDEN | AVALON | SAYBROOKE | OAKLAND | ||
LANDEN | ||||||
AVALON | MAPLE | MAPLE | BIRCH | OAK | ||
SAYBROOKE | OAK | |||||
OAKLAND | ||||||
WESTBURY | ANTIQUE PAINT | AUTUMN | AUTUMN | NATURAL | ||
SINCLAIR | AUTUMN | CAFÉ | CAFÉ | SADDLE | ||
PIONEER | CAFÉ | FAWN | FAWN | SARSAPARILLA | ||
GRAYSON | FAWN | JAVA GLAZE | JAVA GLAZE | UMBER | ||
RADFORD | FLAGSTONE | NATURAL | NATURAL | WHEAT | ||
KORBETT | JAVA GLAZE | PUM. GLAZE | PUM. GLAZE | STANDARD | ||
WINSTEAD | NATURAL | ROUGE | ROUGE | |||
TEAGAN | PUM. GLAZE | SADDLE | SADDLE | |||
EASTLAND | ROUGE | SARSAPARILLA | SARSAPARILLA | |||
WENTWORTH | SADDLE | UMBER | UMBER | |||
BRIARCLIFF | SARSAPARILLA | STANDARD | STANDARD | |||
AYDEN | UMBER | |||||
DRYDEN | WHITE PAINT | |||||
HARRISON | PAINT | |||||
BENTON | STANDARD | |||||
DURHAM | ||||||
OVERTON | ||||||
AUGUSTA | 5-PIECE | SLAB | 5-PIECE | SLAB | ||
NANTUCKET | SLAB | SLAB |
<tbody>
</tbody>
Forgive me I have been doing my research on this and I am just not grasping if there is a way to do what I want with so many different variables. I have tried =INDIRECT but I run into an issue with the names. For example B1:B27 is my Door Styles. I made a list of them and named them DoorStyles, and then put them across the top as reference. From there I labeled D2:D4 as LandenWoods because they are the woods for Landen Door style. The next long list that starts Antique and ends Standard is the Color and I named it LandenColors, they are the colors Landen is available in. Then finally at bottom there is 5-Piece and Slab, I named them LandenDetails. Ok so when I start making what I want it looks like this:
Door Style | Wood | Color | Details |
<tbody>
</tbody>
I need drop downs for each space under those headers. I run into error issues because of the fact there is multiple colors that can use the same type of wood but not the same doorstyle. I know this is asking a lot but can anyone please help. I am using excel 2010, thanks in advance.