An estimate is the same as a bid proposal. I have a item list of Materials and Equipment that have fixed cost rates. I have given each material and piece of equipment and item number on a worksheet page.
On the estimate page I want to pull the item number from the item list Such as item 4100 in column A21, which is a piece of equipment described as a 228 Backhoe in column B21, with a rate of $228 in Column C.
I want to be able to just type in 4100 in one cell, and have the Description appear in another cell and the rate in another cell.