Pull corresponding data from drop down list

[SeeStation]

I created a list of part numbers and prices on one worksheet,"PriceList" in
two columns. (A=Name, B=$) On another worksheet "Configure", in the same
workbook I have one cell that is a drop down list of the part names(P2). I
want the next cell over (Q2) to pull the corresponding price when I choose
the part number from the list. Thanks in advance for your assistance!

 

[Dave Peterson]

=if(p2="","",vlookup(p2,configure!a:b,2,false))

Debra Dalgleish has lots of notes on =vlookup() and =index(match()) here:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble

 

[SeeStation]

Fantastic!

=if(p2="","",vlookup(p2,configure!a:b,2,false))

Debra Dalgleish has lots of notes on =vlookup() and =index(match()) here:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble