Need help creating a formula that will sort and populate based off certain selections

Hi guys,

I hope I can put this in the simplest, and most descriptive terms. I created a sheet that would make bid sheets for possible jobs. The problem with it is I did not have a full list of the items. How it worked was I created drop downs for the items, and next to it it would populate the items price, and from there you would select the markup, and it would auto fill into our bid sheet.

Someone made me a function on here that may work. But I am thinking I will have to create a long list of all the parts or something as there are at least over 500 parts. I am thinking the best way to do this would be to create a sheet that has the vendor, the part item, and the price. But I have no idea how I could utilize this to were it will allow you to search by vendor, and give you an option to select from only those parts, while having it all accessible from one page.

Does that make sense?

Also, one of the things that is looking to be an issue is that will will constantly add items to it, and they formulas would have to be redone every time.

If anyone has any ideas for this, please help.

If this is hard to understand I can create an example(?) of what I need help with.

Hi. Unfortunately your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.