PDA

View Full Version : Solved: Vlook up..?



Mr.G
12-11-2006, 08:00 AM
Why doesn't the temperature look up work?
Can anyone help?

Charlize
12-11-2006, 08:09 AM
Tryapplication.worksheetfunction.vlookup
Charlize

Mr.G
12-11-2006, 08:17 AM
Doesn't work.
Private Sub CTemprature_Change()
TxtFluidDensity.Value = Application.WorksheetFunction.VLookup( _
CTemprature.Value, Range("G5:H25"), 2, False)
End Sub.

Could I let this run over 3 colums,you select temperature and it automatically inserts the density and viscocity?

Erdin? E. Ka
12-11-2006, 08:51 AM
Hi Mr.G,

You should use Val.

Try this;

Private Sub CTemprature_Change()
TxtFluidDensity.Text = Application.VLookup( _
Val(CTemprature.Value), Range("G5:H25"), 2, False)
End Sub

Mr.G
12-11-2006, 09:03 AM
That works!!
Can I link viscocity to that also? It is in ("I5:I25")

Erdin? E. Ka
12-11-2006, 02:44 PM
Is it like this?

Private Sub CTemprature_Change()
TxtFluidDensity.Text = Application.VLookup( _
Val(CTemprature.Value), Range("G5:I25"), 3, False)
End Sub

Mr.G
12-12-2006, 03:01 AM
OK but fluid density is a text box on its own with info in Colum I

Bob Phillips
12-12-2006, 03:43 AM
Private Sub CTemprature_Change()
TxtFluidDensity.Text = Application.VLookup( _
Val(CTemprature.Value), Range("G5:H25"), 2, False)
TxtViscosity = Format(Application.VLookup( _
Val(CTemprature.Value), Range("G5:I25"), 3, False), ".000000")
End Sub

Mr.G
12-12-2006, 03:59 AM
Thanx a lot it works.
Thank you