How do I accomplish this?
I have a table - I'll give you an example of the 2 columns
cell B6 = 2.5 cell D6 = 143
cell B7 = 2.6 cell D7 = 147
cell B8 = 2.7 cell D8 = 151
cell B9 = 2.8 cell D9 = 154
cell B10 = 2.9 cell D10 = 158
(Above is the complete first table)
If the value in cell J5 is 2.5 and a minimum of 143, place a number 1 in
cell N5
If the value in cell J5 is 2.6 and a minimum of 147, place a number 1 in
cell N5
If the value in cell J5 is 2.7 and a minimum of 151, place a number 1 in
cell N5
and so on...
Three other tables continue and are similar to the above table.
Another table looks up values and a number 1 is not placed in a column based
on the values in the table.
Another table looks up values and a number 1 is placed in cell L5 based on
the values in the table.
Another table looks up values and a number 1 is placed in cell M5 based on
the values in the table.
This may not be enough info or I'm not explaining this properly - If anyone
knows what I need, can someone at least guide me in the right direction to
accomplish this task?
Thank you