hello, you are amazing I am learning a lot with you, but my question is : if I want to add Date on the cell, "making 'name, price on the date" how can I do it? and if I want to organize by date to return more than 2 names (each cell), which programador I have to use?
Is it possible to use a VLOOKUP within a Validity > Cell Range formula, where the referenced column index contains an array on each row? For example, You have a product category "kitchen appliances" as the criteria, a "category" column as the search column in the array parameter, and another column referenced by index where the category column has the cell "kitchen appliances" and the value is ={ "Toaster"; "Mixer"; "Coffee Maker"; "Microwave" } And then the options in the dropdown become those four? When I try this only the first option (toaster) is available. Is it possible?
Great Video! You explain things precisely in a clear easy to understand way. Thank you.
If you are watching this in 2020, use ; instead of ,
thank you for a clear and concise tutorial
Is it possible to do it right to left ?
Thanks ! My problem is solved 👍👍👍
Why is my libreoffice sheet is not as colorful as yours?? Thanks for the tutorial sir.
hello, you are amazing I am learning a lot with you, but my question is :
if I want to add Date on the cell, "making 'name, price on the date" how can I do it? and if I want to organize by date to return more than 2 names (each cell), which programador I have to use?
Please make a video between two sheets..
I only get error 502
Is it possible to use a VLOOKUP within a Validity > Cell Range formula, where the referenced column index contains an array on each row?
For example, You have a product category "kitchen appliances" as the criteria, a "category" column as the search column in the array parameter, and another column referenced by index where the category column has the cell "kitchen appliances" and the value is ={ "Toaster"; "Mixer"; "Coffee Maker"; "Microwave" }
And then the options in the dropdown become those four?
When I try this only the first option (toaster) is available. Is it possible?
I followed the steps, but am getting TRUE.
No longer works. Just puts out "invalid value". Someone needs to do an updated video.