Index Match
My first attempt to use this function.
I have a worksheet that has a column (Category). Properties set for dropdown / single select. Rather laborious to manually click on every cell and select.
Two other columns contain Product description column and part number column. The dropdown column places the item in a category.
I have a separate sheet. Each row is populated with description, part number, and category.
Apparently I can do an index/match function in the current dropdown cell (=index....) where it looks in the reference sheet to populate the correct category.
How would that formula be structured?
Thanks in advance.
Answers
-
I am not totally sure of your configuration, but here is how I do it. I always create a column called match, and I put my MATCH formula in there. That will return a number.
The MATCH is pretty straight forward, but if you can't get a number in response, you know you have it wrong. The MATCH is just a reference to the field in the current row that you want to find, the foreign range, and then the sort instruction, which I find is usually a 0. That number relates to how the foreign range is sorted.
And then I create another column for the INDEX. That field has the foreign range, a comma, followed by a reference to the MATCH field.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!