Drag down the formula to the remaining rows. This enters the same formula in the selected cells, which will return a different value in each column. Type the formula and press Ctrl + Shift + Enter. Perhaps I could set up dependent drop-downs somewhere on Sheet 1 and use VLOOKUP to display appropriate dependent drop-down in Column D of Sheet 2? Hope this makes sense. In the first row, select all the cells to be populated (B2:C2 in our example). Drop down list auto populate with VLOOKUP function Drop down list auto populate with an amazing tool More tutorials for drop down list. This tutorial provides two methods to help you solve the problem. 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. For example, when you select Natalia from the drop down, the corresponding score 40 will be populated in E2 as the below screenshot shown. Data source for this validation is the list of names that has been filtered from Column A of Sheet 1. Data validation has been applied to Column C. Sheet 2 is a blank sheet that contains column C and D. The Vlookup function used so far is given below: VLOOKUP (A2&B2 tblData 4 FALSE) Data sheet: Data entry sheet: excel drop-down-menu return vlookup. Then i have used Vlookup, but that only returns the first instance of the combination. But since the amount of data is so big, i gave up on it. Since one person holds various projects, there are repeated names in Column A.Ģ. I thought about dependent drop down lists. Column B has a list of "projects" corresponding to names in Column A. To simply, let's say I have 2 sheets in 1 workbook:ġ. I've been searching all nights and days but couldn't find any solutions for my rather HUGE database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |