Sort in alpha and add numerical value

[stully]

Good afternoon!

I am looking for some help and I don't know if I need a formula or a macro for this...

I have a 2-column worksheet
In Column A is a product Listing.
In Column B is a number listing based on the alpha sort from column A
People will be adding products into cell B2.

How do I get the sheet to add the product that is entered into cell B2 down into column A, sorted A to Z, and then get the correct numerical value in column B?

For example,
They enter in "bleach" in cell B2.
Bleach would then be dropped into Column A, sorted alphabetically, and the corresponding number would be entered into Column B. (so if bleach is the 4th on the list in alpha order, the number in column b would be 4).

Thank you for any help you can give!!

 

[FDibbins]

If you will be entering anything in a cell, and what that entry moved/transferred to another cell, and then sorted, that would require VBA, a formula wont do that for you

 

[stully]

If you will be entering anything in a cell, and what that entry moved/transferred to another cell, and then sorted, that would require VBA, a formula wont do that for you

Thank you! I have not worked a lot with those and am struggling where to begin. I appreciate your help!