2,699 views
Hello dear friends, in this video, I have done a very important project in Excel in detail. We previously had a video on how to create a drop-down list or combo box in Excel.???? ???? • ???? Tutorial on creating a drop-down list or Drop Down... Now in this video, in a much more advanced way, instead of one combo box, we want to have two combo boxes that are related to each other, that is, for example, in the first combo box, we select a province and in the second combo box, the city related to the selected province. To do this project, we need many prerequisites, such as these ???? ????Index function ???? • ???? Index function in Excel ????Match function ???? • ???? Match function tutorial ????Using Index and Match instead of Vlookup ???? • ???? Throw away Vlookup! From now on... ???? Indirect function ???? • ???? Excel tutorial - Address and Indirect functions ???? Relative and absolute generalization ???? • Relative and absolute generalization in Excel