Auto fill of cell with information from seperate sheet
 

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?

Auto fill of cell with information from seperate sheet
 

Use a VLOOKUP formula in G49 of Sheet1

=VLOOKUP(C49,Sheet2!$A$1:$B$100,2,FALSE)

Enter a temperature in C49 to return the SG for that temperature into G49


Gord Dibben MS Excel MVP


On Wed, 13 Jun 2007 16:41:00 -0700, Ray wrote:

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?