Hi
If for example a Listbox was populate with the following list:
The Item's name in the first col and the items value in the second

A1 B1
Item Sq Ft Per Piece
Brick Pavers .33
Plywood 32
Concrete Per Yard 80
Whatever 1

Then elsewhere in the workbook an item is picked from the listbox as
illustrated below. The area B1*C1 is divided by its value to get the amount
needed.
How, can the value of the item picked (in this case plywood -32-) be written
in the formula in d1?


A1 B1 C1 D1
Item Length Width Amount Needed
Plywood 8 8 =(B1*C1) / "the value of plywood"

The answer is 2 of course.


Thanks