I am using Excel 2000 and have a problem.

I have a spreadsheet from an associate that the tracks the purchasing of
steel.

MY PROBLEM:

Currently he types in the steel thickness on column C on a sheet named 2005.

He then looks a another page in the same workbook named Specification to
match up the pounds per square foot. For example 1/4" = 10.21 lbs. per
square foot.

After he looks at the specification page and matches his steel thickness
with the appropriate lbs. per sq. ft. he will put the answer (in this case)
10.210 in column D on the sheet named 2005.

I would really like to create a formula or something that will let him type
in whatever cell he may be at in column c and have the info. in that
particular cell go to the chart on the Specification page and find the
answer and put the answer in column D on the sheet named 2005.

What would be the best way to accomplish this?

Thanks to any and all who contribute!