How to create a vlookup to work with a drop down list

**Breezey** · 11-07-2007, 03:24 PM

hi all,

basicly i need to use the vlookup function i think as i am creating an ordering system but i want a drop down list of all the products so that when i click one the price etc is filled in automaticly if u know what i mean, i have a product list on a seperate sheet and a ordering page on another seperate sheet, that is what im struggling with.

cheers

**shg** · 11-07-2007, 03:25 PM

Breezey,

Please help people help you by changing your thread title to something that gives people a clue as to what you specifically want help with.

**VBA Noob** · 11-07-2007, 03:33 PM

See if this helps

VBA Noob

**Breezey** · 11-07-2007, 03:36 PM

.............

**VBA Noob** · 11-07-2007, 03:41 PM

Post an example so we can see what your trying to do

Note. I changed your title this time. Below are the forum rules which you should read

VBA Noob

**Breezey** · 11-07-2007, 03:56 PM

ok basicly here is the spread sheet and as you cna see there is an order page and a product page, i need to creat a dropdown list of all the products that goes onto the order sheet, then i need to use the vlookup function to get the prices wieghts etc into the order if u see hwta i mean. sorry i am useless at explaing stuff

**VBA Noob** · 11-07-2007, 04:06 PM

See if this helps. Uses a name range for the Item Description e.g Name range is called "Items"

VBA Noob

**Breezey** · 11-07-2007, 04:11 PM

Thankyou sooooooooooooooooooo much your an absoloute star

**VBA Noob** · 11-07-2007, 04:13 PM

Your welcome.

Please remember to follow the forum rules below next time as mentioned

VBA Noob

**Breezey** · 11-07-2007, 04:15 PM

anychance you can delete the thread please, if not what does the ISNA function do?, i have to be able to understand the formula you see

**VBA Noob** · 11-07-2007, 04:24 PM

If the dropdown list is blank and you use

=VLOOKUP($A9,Product_list!$B$4:$G$148,COLUMN(B1),FALSE)

it will return #N/A which is a error. To avoid #N/A I used a if statement to make it blank if an error (true statement) and return the result otherwiser (false statement)

Links may help you further
http://www.bettersolutions.com/excel...O318313331.htm
http://www.j-walk.com/ss/excel/usertips/tip010.htm

VBA Noob