How to get the price group to populate once i have chosen the finish from drop-down?

Hi guys,

Hope you can help.

Here is what I wanna do:

Have a dropdown list of finishes (which is easy) BUT!! When the Finish is chosen I want its price group to be displayed below.

Effectively like this:

FINISH: WHITE
P/GRP: 0

or if I choose

FINISH: ONYX
P/GRP: 4

I used data validation to create the drop down list, and i have a second tab with the said finishes listed, with their price group next to the finish. How do I get the price group to populate once i have chosen the finish? I thought a VLOOKUP based on what was selected in the finish section, but Im tearing my hair out, and I'm bald already!!!

Hope a guru can help

thanks you guys

Please see yellow banner at top of page of how to post as ample workbook.

have attached the sheet with explanation on what i need to do.

thanks

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I have done it for you today.)

Try

=VLOOKUP($E$9,Finishes!$C$2:$E$100,2,0)

=VLOOKUP($E$9,Finishes!$C$2:$E$100,3,0)

You're welcome.

Moderators generally advise that you start a new thread especially if the query isn't covered by your current title.