Excel - Data Validation with the INDIRECT Function - Excel Advanced

[@stappys]

I have used this trick in the past to make my data change per what tab it is pulling the vlookup information from but needed a refresher on how to do it. Love the short, simple and precise explanation and I LOVE the table trick.

[@ChrisMenardTraining]

Great 👍

[@roywilson9580]

That is a useful trick that I have frequently used to produce dependent dropdown lists.

[@liambrennan822]

thanks great options

[@ChrisMenardTraining]

You're welcome!

[@VP-yp8ip]

Very helpful. Thank you so much.

[@ChrisMenardTraining]

You're very welcome!

[@hishamaq8269]

Thank you So much May Allah bless you

[@ChrisMenardTraining]

Thank you too

[@JojoTheWitch]

Great! Thank you!

[@harishsingh_424]

Highly Appreciated

[@ChrisMenardTraining]

Glad to help.

[@yeahyuh1725]

fixed my problem, thank you

[@adamtabor6754]

Very clever.

[@ChrisMenardTraining]

Thank you!

[@romany4all]

Great

[@ChrisMenardTraining]

Thank you!

[@luigibru8677]

Is there a way to apply the Data validation only when a new row is created? Thanks!

[@TrainWithAhmedAtif]

perfect

[@user-bn5oo1qt3i]

ty

[@ROSEKAURA]

Hi! I need the help in excel. I have the data in excel. Column A and Column B. A1 = 1.5, a2=2, a3=2, a4=2.5, a5=3, a6=3. and comparing data in column b, b1=6203, b2=6203, c3=6204, c4=6205, c5=6205, c6=6206. now I need the validation list formula. If I type in cell L184=1.5 then in the list 6203 may appear as it is on a1 and on b1. if cell L184=2 then in the list 6203 and 6204 seperately show as the reference data is on a2, a3 and on b2, b3. if cell L184=2.5 then in the validation list 6205 may show as it is related with cell a4 and b4. if cell L184=3 then in the validation list may show 6205 and 6206 seperately as it is related with cell a5, a6 and b5, b5. please give me the formula for validation list.