What I am trying to do is have a specific number entered into a cell when
another cell has a specific number in it.

Example:

sheet 1 - c49 has '67' and g49 must say '.988'

('67' is a temp. and '.988' is a specific gravity of a liquid)

sheet 2 column 1 has numbers 0 through 100 (tempertures)
sheet 2 column 2 has corresponding numbers for column 1 ie...a68 will equal
..988 (specific gravity)

Isn't there funtion that will automatically enter the specific gravity for
the entered temperture?