Ok I got the first 2 questions working so thanks a lot Ardus. I need help on
the last one though. Are you sure I can use Vlookup on a list box? Let me
explain my problem again. A person clicks a cell and a list of several
choices drop down which they get to pick from. I need another cell displaying
a number which depends on what the person picks from the list box. So if cell
A-10 is clicked and 15 choices pop down and a person clicks "Bolts", a new
cell lets say C-10 will display 5.00. If A-10 was selected with "Screws" then
C-10 will display 4.00. Is this possible?