I would like to stay away from macros if possible.

I have a multi-part question that ties together.

1) How do I tie two or more columns together so that when I sort column A
alphabetically, column B's cells move with column A? (Column A is Text,
Column B is Numbers).

2) I have created a listbox that allows the user to choose an input on a
form from Column A. I want to write a formula that spits-out the number from
Column B in a specific cell when the user selects the input from the list box.

Thanks