Drop down list and bring in additional data

**ROTHERS** · 02-18-2014, 05:04 AM

Hi,

Newbie here.
I want to use excel to create quotations for customers. (currently doing it in word)
Tab 1 is the quote, has 4 columns, part number, description, cost, yearly maintenance
Tab 2 has all the things we sell, part number, description, cost, yearly maintenance. 150 lines.

So, Tab 1, description column is a drop down box from Tab 2. Working fine.

Question.
When an item is selected from the drop down, how do I get it to then bring from tab 2 the part number, cost and yearly maintenance.

Thanks in advance !

Rothers

**AliGW** · 02-18-2014, 05:09 AM

Without seeing the file, I can't provide an exact answer, but from what you have described, I'd use a VLOOKUP formula.

**TMS** · 02-18-2014, 05:12 AM

You would use VLOOKUP or INDEX/MATCH for that.

Regards, TMS

**ROTHERS** · 02-18-2014, 05:21 AM

thanks, I'll feedback later with my success...

**TMS** · 02-18-2014, 05:29 AM

If you upload a sample workbook, we can help you with a specific solution.

**BadlySpelledBuoy** · 02-18-2014, 05:35 AM

Very basic example attached.

I've included a VLOOKUP example and an INDEX/MATCH example.

Hopefully straightforward enough to understand, but happy to explain further if need be.

BSB.

**ROTHERS** · 02-18-2014, 05:42 AM

a FINDUS moment (Showing my age here).
SUCCESS (on a plate for you, crap 1980's advert).

Thanks everyone, you have helped me solve what was a massive problem.

**TMS** · 02-18-2014, 06:24 AM

Sadly, I remember it too

To build on BadlySpelledBuoy's example, if you define your Parts List as a Table, you can use Table references. Not necessarily shorter (mostly not), but a lot easier to read.

See the updated example.

Regards, TMS

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.