K
Kim
I have the following table I want to set up in Excel. My question is if a
user keys a Spec and a Spec Gravity number, how do I get Excel to look up the
corresponding intersection of the two numbers.
Spec Spec Gravity
1.01 1.02 1.03 1.04 1.2
1058TT 3.38 3.343 3.35 3.7 3.94
2534C 4.58 4.67 4.75 4.8 5.08
1058TC 3.97 3.99 4.02 4.05 4.75
What kind of formula would work best for this application.
Thanks
user keys a Spec and a Spec Gravity number, how do I get Excel to look up the
corresponding intersection of the two numbers.
Spec Spec Gravity
1.01 1.02 1.03 1.04 1.2
1058TT 3.38 3.343 3.35 3.7 3.94
2534C 4.58 4.67 4.75 4.8 5.08
1058TC 3.97 3.99 4.02 4.05 4.75
What kind of formula would work best for this application.
Thanks