If Then formula w/ alphanumeric listbox

[David C]

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

 

[David Biddulph]

For 1), select the range of cells that you want to sort (rows and columns)
before you ask Excel to sort. Don't leave Excel to gueds which cells you
want to include.