compare 2 column cells and return the adjacent columns cells data of the cell
In cell (P4) there is a formula that gives a number in C-mils (example "89268") based on several manualy inputer numbers.
I have a chart that has (AT4) through (AT33) each row of this column has a higher C-mill number example (AT14) = 83690 and (AT15) = 105600. in the column to the right of (AU) is a I want to reference back to (Q4).
such as the number in P4 is =(AT14) and <(AT15) and I want the number in (AU15) "1/0" is returned to (Q4).
remember the number in (P1) could be any number between "1 and 2,000,000" and this range is not divided equaly between cells (AT4) and (AT33). The number to the right in Column (AU) must be the cell that is the greater of the 2 cell number of the 2 adjacent cells in Column (AT) =(AT14) <(AT15).
|
Similar Threads
Threaded Mode
