![]() ![]() That’s why you have to add “-1” after the match function MATCH($D13,$D$3:$F$3,0)-1. □ The MATCH function counts the columns as 1,2,3 whereas the OFFSET function counts them as 0,1,2. Read more: Multiple Dependent Drop-Down List Excel VBA Now if we choose “Europe” and the country “Germany” the list will show us the corresponding results.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |