I have a colmun in my main worksheet that I use a drop down list in. I want
to select something from the drop down list on the main worksheet, BUT have
it return a different value from another column in my list worksheet. I
have set up the list worksheet to have the drop down items in column A, and
the value I want in the same row in column C.