See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Retired Bill" <Retired wrote in message
...
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.