Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to auto fill information from a table to another sheet | Excel Worksheet Functions | |||
Fill a seperate cell with info depending on the input in another c | Excel Discussion (Misc queries) | |||
auto fill from another sheet in excel | Excel Worksheet Functions | |||
Auto-fill cell based on adjacent cell information.. | Excel Worksheet Functions | |||
Seperate Cell Information (lastname, firstname) | Excel Discussion (Misc queries) |