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 👍
@roywilson958011 ай бұрын
That is a useful trick that I have frequently used to produce dependent dropdown lists.
@liambrennan82217 күн бұрын
thanks great options
@ChrisMenardTraining12 күн бұрын
You're welcome!
@VP-yp8ip5 ай бұрын
Very helpful. Thank you so much.
@ChrisMenardTraining5 ай бұрын
You're very welcome!
@hishamaq8269Ай бұрын
Thank you So much May Allah bless you
@ChrisMenardTrainingАй бұрын
Thank you too
@JojoTheWitchАй бұрын
Great! Thank you!
@harishsingh_42411 ай бұрын
Highly Appreciated
@ChrisMenardTraining11 ай бұрын
Glad to help.
@yeahyuh17255 ай бұрын
fixed my problem, thank you
@adamtabor675411 ай бұрын
Very clever.
@ChrisMenardTraining11 ай бұрын
Thank you!
@romany4all11 ай бұрын
Great
@ChrisMenardTraining11 ай бұрын
Thank you!
@luigibru867711 ай бұрын
Is there a way to apply the Data validation only when a new row is created? Thanks!
@TrainWithAhmedAtif8 ай бұрын
perfect
@user-bn5oo1qt3i6 ай бұрын
ty
@ROSEKAURA5 ай бұрын
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.