If you are in columns A,B and C
try
=vlookup(max(A:A)-.1,B:C,2,false)
"Ian Winter" wrote:
I find a maximum value form an excel spreadsheet column.
Using this value I wish to subtract 0.1 and then find a value in a further
column which corresponds with this newly calculated value., then taking this
value from an additional column in this row find the vlaue and copy the
result into a new cell
|