Hi there, hoping someone can help me. If you can many thanks in advance. I've been working on a project and this hurdle is my last missing piece.
Example:
I have a vlookup in place which returns a price based on 2 selections. firstly in A1 i have a data validation list of clothing items and then in B2 i have a data validation list of colours. In C1 I have my vlookup which works and returns my price based on me choosing, for example, a shirt in blue.
What i need though is that once that single choice of shirt in blue is made i would like a separate area which automatically populates with prices for shirts only in the other 5 colours available.
Many thanks!
Example:
I have a vlookup in place which returns a price based on 2 selections. firstly in A1 i have a data validation list of clothing items and then in B2 i have a data validation list of colours. In C1 I have my vlookup which works and returns my price based on me choosing, for example, a shirt in blue.
What i need though is that once that single choice of shirt in blue is made i would like a separate area which automatically populates with prices for shirts only in the other 5 colours available.
Many thanks!