Validation List

S

Steve HKG

I have already set up Column B with a validation list to select the 'Service'
and Column C a second validation list with a set of 'SubServices' based on
Column B.

The formuales are as follows:-
Column B
=IF(C5="",ServicesList,INDEX(ServicesColumn,MATCH(D5,MaterialColumn,0)))

Column
=OFFSET(ServicesStart,MATCH(B5,ServicesColumn,0)-1,1,COUNTIF(ServicesColumn,B5),1)


Now I wish to extend this selection list to Column D which will provide a
selection based on Column C. Column D will be called 'ServiceSize', and shall
contain variosu pipe size information.

Looks like I need a MATCH criteria.

What formulae should I use for the Column D?

I have been playing aroud and have setup Column D to have a duplicate
'SubServices List' with Column E being the 'ServicesSize'.

Column
=IF(D5="",SubServicesList,INDEX(SubServicesColumn,MATCH(D5,ServiceSizeColumn,0)))

Column
=OFFSET(SubServicesStart,MATCH(D5,SubServicesColumn,0)-1,1,COUNTIF(SubServicesColumn,D5),1)

I need a method to join the 2 Column C and Column D together, or remove
Column D altogether. Any suggestions? Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation of cell based on Drop down list 1
What is the "--" (double dash) in MS Excel formula? 2
Find the next row... 0
Horizontal and Vertical lookup 2
SUM determined by drop-down list 9
Sumproduct giving #Value error 5
Needs help combining functions. 3
Adding formula 1

Top