Over 1000 Items to Look up in a column, Best Formula to Use

[atvsource]

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.

 

[tusharm]

Why reinvent the wheel? Use Excel's find capability. CTRL+f will get you started.

 

[atvsource]

that's sweet... never new that... easy as making mud pies.... now just have to tell everyone else in the office!!

 

[tusharm]