Question using DGET function

J

Jasonm

Good evening group! I am trying to use the DGET function to return one value
from a group of cells. My table structure looks like this:

Temp pH Cl2 Min
4.90 5.90 0.4 137
4.90 5.90 0.6 141
4.90 5.90 0.8 145

Through
25.00 9.00 1.8 86
25.00 9.00 2.0 89
25.00 9.00 2.2 90
25.00 9.00 2.4 92


There are 585 rows in all and each is unique based on the first three rows.

I originally sturcutred my DGET where my criteria were formulas that looked
up "rounded" results, and this works for SOME results, but there isn't a
real pattern to when it stops...

When I use a similar stucture and TYPE in the values that the formulas
return in the previous paragraph the DGET works everytime!

the structure of my criteria is:
Temp pH Cl2
20.00 8.50 1.20

Where "20" is returned from a LOOKUP function because I am trying to round
the Temp to increments of 5 degrees C.
pH of increments of .5 (but the user can enter any ph into a field)

Does any of that make any sense? If you can help or suggest another method
in excel to get at what I am trying to do I would be very appreciative.

Thanks, Jasonm
 
J

Jasonm

Thanks for reading my thread anyway... If you want to answer I will still
read and appreciate your response, but it seems like I am better off moving
all my data to Access where I can better manipulate it...

Thanks again,
Jasonm
 
Top