User Profile
GLedesma26
Copper Contributor
Joined Sep 22, 2022
User Widgets
Recent Discussions
Re: Match-Index with variable column
Hi HansVogelaar https://docs.google.com/spreadsheets/d/1WEo43g1xBpRYPhPwu_SEKJQd4e3ryppfXbh6u0Pl-oI/edit#gid=0 Here I created a google sheet with an example of the case. Of course, in reality, I will have many more categories and subcategories, and even some of them might have the same name and yet get a different number. You should be able to make comments on the sheet. Thank you in advance!!!4.3KViews0likes2CommentsMatch-Index with variable column
Hi there, I have had this challenge for a while that I am not able to overcome. I have a long database of articles to which I want to give a number. Each article (row) has a Category and a Subcategory (2 columns in the table). To give a number to the Category was easy by using the INDEX&MATCH functions (instead of VLOOKUP). What I did was create a little table with all my categories and a number next to them, nothing exotic. Now, my subcategories are dependant on the Category (that is, each Categroy has different Subcategories), and I want to give numbers to the subcategories, always going from 1 to X for each Category. I thought I could do something similar than my previous step, but this INDEX&MATCH or the VLOOKUP functions don't allow you to look for something in array and indicate in which column they should look for the item. Can someone try to give me a hand?Solved4.5KViews0likes4Comments
Recent Blog Articles
No content to show