If Then formula w/ alphanumeric listbox
 

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

If Then formula w/ alphanumeric listbox
 

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.
--
David Biddulph

"David C" wrote in message
...
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