![]() ![]() STEP 7: Choose List in the Allow drop-down, and in the Source area, type in =INDIRECT($H$10) Select the cell where you want to place the indirect data validation list. ![]() This will return the Named Range values from the drop-down list selected in cell H10.Ĭlick OK. You will get this error initially, just click Yes to continue:įor example, if we pick Meat in the Category List dropdown, INDIRECT will calculate this as the “Meat” Named Range we defined earlier and return its values in the Content List dropdown.I've been searching all nights and days but couldn't find any solutions for my rather HUGE database. To simply, let's say I have 2 sheets in 1 workbook:ġ. Since one person holds various projects, there are repeated names in Column A.Ģ.Ĭolumn B has a list of "projects" corresponding to names in Column A. Sheet 2 is a blank sheet that contains column C and D. In this scenario, we want the timestamp to be in Column A when entering data into Column B. Type the following formula into A1 IF (B1,IF (A1,NOW (),A1),) Type something into Column B.ĭata validation has been applied to Column C. Data source for this validation is the list of names that has been filtered from Column A of Sheet 1.ĭrag the formula in Column A down to allow time to stamp all down your Column. What I wish to "magically happen" is after selecting a name from the drop-down list on Column C of Sheet 2, another drop-down list pop up for Column D that only displays projects corresponding to the name selected. ![]() #VLOOKUP WITH DROP DOWN MAC EXCEL 2013 ALL SAME RESPONSE PDF#. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |