Auto fill of cell with information from seperate sheet

G

Guest

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?
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
copying only selected data from Sheet 1 to Sheet 2 2
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Excel If a Cell Contains a Certain Text (From Another Table) 0
Auto populate cell with info on other cell (Sheet) 4
Display contents of cell based on criteria 2
Auto-adding text when a certain number is input 1
multiple sheet macro 3

Top