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.
Help Article Resources
Check out the Formula Handbook template!