Index Match function for multiple linked variables
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
|