Simple estimate with price list

[superman_kd]

I am trying to make a simple estimate sheet with a price list. I would think this should be pretty easy in FMP or even excel but I cannot find or create a practical solution. I had a FMP db that was almost there but every entry in the price list is a different record and that really screws things up for me. I would like to have a different record for each job. All I need is for the unit cost to autofil if the description on the estamate layout matches any description on the price list layout. Not all of the items will be in the price list so I need to be able overwrite the field. Most software solutions are really junkie and needlessly complicated. I am really lost and confused. I would think this would be a fairly common thing useful in many businesses. Any help or direction would be greatly appreciated.

Please help!