CL

Assuming DV drop-down cell is A1 and contains a list of items to pick from.

Assuming your source table is B1:C10 and column B contains items from the
drop-down list.

In D1 enter =VLOOKUP(A1,B1:C10,2,FALSE) to return what is in Column C

For more on this(with pictures) see Debra Dalgleish's site.

Note the use of named ranges if using another sheet for the DV list source.

http://www.contextures.on.ca/xlDataVal01.html

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben Excel MVP

On Wed, 19 Jan 2005 14:01:02 -0800, "CL" wrote:

How do I use drop down list selections/values in a vlook up formula?

What I want to to do is when some one makes a selecton from a down list, my
vlook up formula will look up this value in a source and return another value