Search and Fetch

[roundco]

Hello,
I am needing to know what kind of code I need to write to be able to select data from one page and have my selection and the price of the item pulled through to my summary page. My project is dealing with a certain type of boat and the price of each boat model as well as the option to have three different motors all varying in price. So, what I am trying to be able to do is select any given boat, with its option of motor included, and have that boat and the price pulled through to my summary page, as well as any of the possible options for the boat. Any help is greatly appreciated! Thank you.

[FDibbins]

Thanks for starting a new thread

You have this in the VBA forum, but you can do this with regular formulas. As a start, I have created a dropdown for the boat type and the options, as well as index/match to pull in the amount

I used 1 sheet for the basic boat and motor types, and my layout may not be exactly what you want, but take a look at the attached and let me know what you think?

[JBeaucaire]

Here's my take on your project.

[roundco]

Thank you very much! These are both very helpful!

[JBeaucaire]

I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above to mark a thread as SOLVED. Thanks.