find closest value ?? (Excel 2000)

[Matix]

Hi lounge,

I am trying to find a value of water % if my total solution is a typed in value. I thought I could use a simple vlookup but I was wrong the value has to be exact to to find it in a vlookup, is there another way to find do this.

What I have is a table from col. a: g with values. in col. I:K i can type a total solution amt in gram and i will return how much water is in the solution. or some where in col f.

thanks for reading

[HansV]

VLOOKUP can do a "fuzzy" lookup if you omit the last argument (or supply TRUE instead of FALSE). However, in your sample worksheet, you're trying to look up 374.31 in a column of numbers ranging from 588 to 626, so none of the values even comes near. Can you explain more clearly what you want to accomplish?

[sdckapr]

If you are trying to do an extrapolation from the data you can extend the line with:

=TREND(F13:F73,E13:E73,I13)

Though it matches the "extended trendline", the number does not seem that reasonable for "reality" since it is nearly 200% water

Steve