Values dependant on previous values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I need to build a spreadsheet which when a person selects a particular
option on one column than options dependant on that selection are given in
the next.

So for example if car colour blue us selected in column A, then black,
beige and blue are options for the interior in column B, but if red colour is
selected, then beige, red and green are displayed in then next column.

Help I'm new to complex formlas in excel (if this is complex!)

Thanks for looking
 
Back
Top