How should I do this?

[Bernard Liengme]

Read Help on VLOOKUP and come back with any questions.
Tells us how the data in Specifications is arranged.
best wishes

 

[John Kitchens]

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!

 

[L. Howard Kittle]

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