Use data validation for the lookup and set your vlookup formula to refer to
that value: Say you had an array of of two columns and several rows with
items in column A and prices in column B. In the cell you want your user to
enter information select data, validation and then select the list option and
for the list select the items in column A of your array. In the cell you
want the information returned to use the vlookup function to look up the
price based on the item selected, vlookup(array,column#).
Gary

"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