Validating drop down list
Here is our 20 minute video with various techniques for Excel Lists, Drop Downs and Data Validation.
Please note that the video was made using Excel 2010, hence the specific menu and look will be for Excel 2010.
Please send corrections and suggested improvements to [email protected] As of January 2013, Opera had the most complete support for these new input elements, followed closely by Chrome.
If ref_text is not a valid cell reference, then INDIRECT function will return #REF error.In this article, we will use INDIRECT function to get the output.INDIRECT: Returns the reference specified by a text string.The second argument A1 refers to a logical value that specifies type of reference is contained in the cell ref_text.If a1 is TRUE or omitted then ref_text is determined as A1-style reference.