Hello all,

I'm working on a web-based form. I am trying to find the source code
for something that will allow me to do the following novel procedure
with a pull-down menu and a text box: There is a pull-down menu, and
another text box right besides the pull-down menu. The pull-down menu
has the names of all the states in the USA in it. When one state is
selected, the text box is automatically populated with the capital of
that state.

In MS Excel, I've created a novel way to handle this issue using
Boolean logic. Unfortunately, I can only have 7 states in my pull-down
menu, and the source code is very unwieldy:

IF(Sheet2!D1=1,Sheet2!A1, IF(Sheet2!$D$1=2,Sheet2!A2,
IF(Sheet2!$D$1=3,Sheet2!A3, IF(Sheet2!$D$1=4,Sheet2!A4,
IF(Sheet2!$D$1=5,Sheet2!A5, IF(Sheet2!$D$1=6,Sheet2!A6,
IF(Sheet2!$D$1=7,Sheet2!A7, IF(Sheet2!$D$1=8,Sheet2!A8))))))))