Data Validation List based on value in a cell

[Yecart77]

Hi All,

I am trying to install xl2bb but and having issues, I hope this One Drive link works, please let me know if it doesn't work.

https://1drv.ms/x/s!AjDNnHmvN7vpjWN6bN904HtsWa2g?e=iggjpH

In Excel 2016, I am wanting to create a Data Validation (DV) List in Column D based in the value in Column C.

The value in Column C is returned via a formula.

If the value in Column C is "Single", I would like a DV list containing three options in G5,G6,G7.

If the value in Column C is "Batch", I would like a DV list containing two options in H5,H6.

Many thank yous to anyone with ideas.

 

[Georgiboy]

You could try:

Make the range G5:G7 a table and name it 'Single'
Make the range H5:H6 a table and name it 'Batch'

For the DV formula try:

=INDIRECT(C3)

Book1
	B	C	D	E	F	G	H	I
2
3		Single			Table Name:	Single	Batch
4		Batch				Single	Batch
5						1	4
6						2	5
7						3
8
Sheet1

Cell Formulas
Range	Formula
C3	C3	="Single"
C4	C4	="Batch"

Cells with Data Validation
Cell	Allow	Criteria
D3:D4	List	=INDIRECT(C3)