Searching for the nearest value

I have created a spreadsheet containing several rows and columns each
with
a numerical value to 3 decimal places. The values in each cell
correspond to particular tooling requirements in my industry that I
have to select on a regular basis.
For instance:
I might be given 2 values of: 31.925 + 3.000 for example.
I then need to identify how many cells in my spreadsheet contain the
sum of
these 2 values to enable me to chose the most efficient tooling.

eg.

79.375 63.500 52.917 45.357 39.688 35.278 31.750
77.788 62.230 51.858 44.450 38.894 34.572 31.115
76.994 61.595 51.329 43.996 38.497 34.219 30.798
76.200 60.960 50.800 43.543 38.100 33.867 30.480
74.613 59.690 49.742 42.636 37.306 33.161 29.845
71.438 57.150 47.625 40.821 35.719 31.750 28.575
69.850 55.880 46.567 39.914 34.925 31.044 27.940
68.263 54.610 45.508 39.007 34.131 30.339 27.305
66.675 53.340 44.450 38.100 33.338 29.633 26.670
65.088 52.070 43.392 37.193 32.544 28.928 26.035
63.500 50.800 42.333 36.286 31.750 28.222 25.400
62.706 50.165 41.804 35.832 31.353 27.869 25.083

Can anyone suggest the best method I should use to carry out this
procedure?
Formula, Search function?

Your help is greatly appreciated.

Abidan


--
Abidan
------------------------------------------------------------------------
Abidan's Profile: http://www.excelforum.com/member.php...o&userid=37286
View this thread: http://www.excelforum.com/showthread...hreadid=569997

If you want to identify an exact match, the easiest way is probably with
conditional formatting.

Assuming you enter your 2 values in A1 & B1, and add them together in C1,
then select all your "data" cells, goto FormatConditional Formatting and
set condition 1 to Cell Value Is equal to =$C$1 and choose a format to
highlight the cell(s).

--
Ian
--
"Abidan" wrote in
message ...

I have created a spreadsheet containing several rows and columns each
with
a numerical value to 3 decimal places. The values in each cell
correspond to particular tooling requirements in my industry that I
have to select on a regular basis.
For instance:
I might be given 2 values of: 31.925 + 3.000 for example.
I then need to identify how many cells in my spreadsheet contain the
sum of
these 2 values to enable me to chose the most efficient tooling.

eg.

79.375 63.500 52.917 45.357 39.688 35.278 31.750
77.788 62.230 51.858 44.450 38.894 34.572 31.115
76.994 61.595 51.329 43.996 38.497 34.219 30.798
76.200 60.960 50.800 43.543 38.100 33.867 30.480
74.613 59.690 49.742 42.636 37.306 33.161 29.845
71.438 57.150 47.625 40.821 35.719 31.750 28.575
69.850 55.880 46.567 39.914 34.925 31.044 27.940
68.263 54.610 45.508 39.007 34.131 30.339 27.305
66.675 53.340 44.450 38.100 33.338 29.633 26.670
65.088 52.070 43.392 37.193 32.544 28.928 26.035
63.500 50.800 42.333 36.286 31.750 28.222 25.400
62.706 50.165 41.804 35.832 31.353 27.869 25.083

Can anyone suggest the best method I should use to carry out this
procedure?
Formula, Search function?

Your help is greatly appreciated.

Abidan


--
Abidan
------------------------------------------------------------------------
Abidan's Profile:
http://www.excelforum.com/member.php...o&userid=37286
View this thread: http://www.excelforum.com/showthread...hreadid=569997