How should I do this?

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!

Read Help on VLOOKUP and come back with any questions.
Tells us how the data in Specifications is arranged.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"John Kitchens" <ironax@pineland.net> wrote in message
news:dkr32d0evv@enews4.newsguy.com...
>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!
>
>

Hi John,

With the thickness in column D and weight in column E of the second sheet,
this formula in sheet 1, =VLOOKUP(A1,Sheet2!D2:E6,2,).

Enter the thickness to lookup in A1.

Thickness Weight
0.125 10.21
0.250 20.24
0.200 30.61
0.750 50.85
1.000 61.22


HTH
Regards,
Howard



"John Kitchens" <ironax@pineland.net> wrote in message
news:dkr32d0evv@enews4.newsguy.com...
>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!
>
>