Excel allows one to create a drop-down list using data validation. This is to facilitate data entry and to limit the entries to previously defined elements. There are numerous application examples for the function. For example, you can equip the address lines of an invoice with the data tool and change the recipient with a simple click.
Excel 2010: Create drop-down list and VLOOKUP
-
-
Hallo,
can someone tell me why I cannot select the "data release" function?
(in Excel 2010 and 2003)Thank you
-
Hallo,
since nobody wants to help you with your question ...
Can you write your problem in individual steps and upload a screenshot (picture, graphic or illustration)?
-
thank you!
helped me a lot -
Thanks for the explanation! Helped me a lot.
Unfortunately it is wrong! Germany now has FOUR * ggg * WORLD CHAMPIONSHIP 2014 titles -
Of course you are absolutely right! Yeah
-
Super ingeniously written, a formula has never been so easily recreated, but ask now, I now have my formula and it works, I added an addition of the unit of my table, but now I am still faced with the problem that #NV is , as long as no value is entered, somehow impractical, but something should be wrong with my formula, any idea?
=WENN(ISTNV(SVERWEIS([@Leistungen];Preisliste!D6:H57;4;FALSCH))*[@Einheit]);0;(SVERWEIS([@Leistungen];Preisliste!D6:H57;4;FALSCH))*[@Einheit])