Great explanation & demonstration, worked perfectly. I did find that if the title is mad up of 2 or more words that you have to use the 'underscore' character instead of a space
@MIA-hc7nm Жыл бұрын
Soooo much easier than all the other videos I watched. Thank you!
@airo_craft700010 ай бұрын
I do agree with you ! Watched many hours of vid and this one took me only 5 minutes .
@Adityaaani7 ай бұрын
Thank you ! You explained very precisely which solved my issue..
@grace_chic Жыл бұрын
very helpful, and this is the kind of tutorial that I'm looking for. Thank you very much!
@dumarsrl6151 Жыл бұрын
but youre not linking anything, I mean how does it know that "Income" is linked to "service, products, byproducts". This just shows how to connect C7 to D column. I already named ranges, have the drop down lists, but my first column doesn't know that is supposed to be linked to the items on the second column. Thats my main problem
@SarahJackCrane Жыл бұрын
Thank you so much....this video was the answer I've been search for!
@GollapudiShanmukh3 ай бұрын
Thank you very much. Resolved my issue. I thought it was by using formulae. It is very simple.
@emiliomola6479 Жыл бұрын
Thank you for this! I got stuck using the offset and match functions using tables. The 'Create from Selection" works great.
@oneworldnovel10 ай бұрын
Hi I want to know that if I select 1 drop down from one column then the other column drop down should appear automatically, As the attributes are one one each in both the columns
@kumaras6912 Жыл бұрын
Thank you very much :-) It's working and very helpful.
@lucionelucione Жыл бұрын
Working. Question: after i complete a row, it is possible to modify the second variable and it doesnt appear an error. How is it possible to avoid someone can change second or third variable that is not dependent from first one.
@SeemaSharma-lj3cf Жыл бұрын
Very well explained.
@CuteKashvi1011 ай бұрын
Really good and help us
@rubiindia Жыл бұрын
Bro can you teach us how to make special uinque identify no as per multiple dependent selection like if let's asume income have id of 101 in the ref list and as per ref list byProduct with id 112 and 3rd quality plastic pipe id is 045 then in the uqiue id for this will show like 101-102-045 like this how we achive this in the new column like UID for that product
@jodu158410 ай бұрын
How it will works, if i have 25 main, 535 2nd and 5000+ in third cell ?
@karaniparshotam9324 Жыл бұрын
Hey do you have a ready spreadsheet for accounts?
@ramadanibrahim49325 ай бұрын
thank you so much sir, if you please for example what if i want like Account Category Account Name Transaction Details Income Income Income
@vickyeric6030 Жыл бұрын
Hi , After applying indirect formula in Data validation and clicked out , but nothing is showing in drop down list
@andreawilhelm8768 Жыл бұрын
I am having same problem
@andreawilhelm8768 Жыл бұрын
Apparently spaces must be removed between words or numbers in drop down lists example Product Name=ProductName. This video only uses one word phrases in drop down lists.
@vickyeric6030 Жыл бұрын
@@andreawilhelm8768 exactly
@kikyarsanfa Жыл бұрын
Hi thanks for the video! I Have question how if i have different account name with same transaction details? for example there are 5 account name. Office Warehouse Laboratory Import Export office, warehouse, and laboratory have different transcaction details. import and export should have same option. Would appreciate if you can assist me. Thank you
@abdulhamidalhaddadi22556 ай бұрын
The first column working fine, but the indirect It does not show any. MS Excel 2019.
@vikaskkumar277710 ай бұрын
Thanks
@dustanpalistianto64272 ай бұрын
can you help me???....i have problem with my multiple dropdown....it can't work , i have been trying many time but it have same problem
@waibiofficialАй бұрын
i also having the same issue.. 😢
@JDJ_JessDaniel Жыл бұрын
Nice tutorial
@selvak56523 ай бұрын
For Income the third level dropdown is less, whereas for Expense, there are more, so u skipped doing for that so that you proving that this will work for small amount of data. What will happen for more values in third level data?
@someguy297211 ай бұрын
8:40 this is where it stops working for me. Still have no idea why I can't get a 3rd dependent list to work and I've probably watched every video on the web on this by now...
@peacefulminds196110 ай бұрын
Same for me too
@satishpoojari123 Жыл бұрын
Its helpfull
@ABellaLuna Жыл бұрын
Can this be done for more than 3 levels?
@JDJ_JessDaniel Жыл бұрын
Sure
@needizone4952 Жыл бұрын
Awesome
@missniral5046 Жыл бұрын
This formula using... Data evaluation error comming
@alializadeh8195 Жыл бұрын
Thanx
@Colin-Fenix5 ай бұрын
This does not work when using tables!
@paolorucco500410 ай бұрын
The indirect function doesn't work. I'm sorry about that, it was the easiest way I found so far.