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