And what is an estimate?
And what are rules to calculate it?

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.

Hello and thanks for the information. The formula is exactly what I need it to do. I'm guessing I need to do some other steps to my worksheet to make this work, like define names maybe? Not sure how to set that all up. Attaching my workbook for you to see

Attached Files

J & S Estimate Worksheet.xlsx (22.0 KB, 12 views)

I attached the wrong Workbook. Here is the correct one. Thank You!

Hello again, I got the formula to work. I had to redefine the name so it would work in other cells, but it turned out great. Thank you so much for the help. I've never used the IFERROR formula, this is a new experience for me. Thanks again, you have solved my problem.