Could part of my problem be that some of the suff in my list has 5"
Reynolds and I think the Parentheses could mess it up.

My first drop down list is : The information for this is on Sheet 2,
cells A1-A15
The drop down list is located on Sheet 1 cell A7 I want the price to go
into cell C7 on sheet 1.
5" GUTTER
5" REYNOLDS
5" REYNOLDS P/U
5" ROLLEX
5" ROLLEX P/U
5" ALSIDE
5" ALSIDE P/U
5" ALCOA
5" ALCOA P/U
5" COPPER
5" COPPER HR
5" QUALITY EDGE
5" QUALITY EDGE P/U
5" GALV HR
5" GALV

The price list for the above items is located on sheet 2, cells
A42-A56

0
1.15
1.10
1.15
1.10
1.20
1.15
1.23
1.18
6.75
6.75
1.23
1.23
2.20
2.40


Thanks for the help I am still trying to learn this program, Thanks for
your time Scott


--
badgrandntl
------------------------------------------------------------------------
badgrandntl's Profile: http://www.excelforum.com/member.php...o&userid=31035
View this thread: http://www.excelforum.com/showthread...hreadid=507020