I am currently working on a project for my ICT class at school, and I am basing it upon a bike shop. The idea is that there will be a customer PC available with a list of components and bike parts that we sell, and there is also a dream bike page. The dream bike page means that the customer can select an item from a drop down list (successfully completed) and then there would be a price which will automatically change with each item. However the list is on a different worksheet to the dream bike and it is on the dream bike worksheet that I need the numbers to appear. Should I use a VLOOKUP table for this or is there another method, it is really annoying and I need an answer reasonably quickly so if anyone has any suggestions, please respond ASAP, I would be most grateful! Thanks for your time!

Sounds about right to me, here's some guidance with the syntax:

http://www.utteraccess.com/forums/showthre...p?Number=301298