Here's my situation, I've got over 1000 inventory items in a column with the Quantity of each in the column next to it. I'm trying to make it easy to find the item without scrolling through the list.
The item name and quantity are setup in two columns, column a and column b. I would like to have a cell where you enter the items name and once you hit return, it will take you to the the item in the column and then highlight the quantity.
My question is, would INDEX or MATCH be the best choice for this? In addition, what would the best formula be for such a thing.
The item name and quantity are setup in two columns, column a and column b. I would like to have a cell where you enter the items name and once you hit return, it will take you to the the item in the column and then highlight the quantity.
My question is, would INDEX or MATCH be the best choice for this? In addition, what would the best formula be for such a thing.