Hi Bob

Would you be prepared to insert a new column at C (hidden if required)?
If so, in this column enter the formula
=ABS((A1+B1)-3.14)

Then
=INDEX(D1:D5,MATCH(MIN($C$1:$C$5),$C$1:$C$5))
Drag across to pick up the data from columns E,F and G.

Regards

Roger Govier


Bob wrote:
I need the closest values to both 0.00 on column A and 3.14 in column b
So for example:
A B
1.2 9.5
0.7 4.3
.003 3.2
-.02 1.5
-.08 -3.9

So for this example Row 3 is the closest to the target values.
The sheet would return The values from row 3 in columns C,D,E and F

I hope that's much clearer!

Thanks!

Bob