Hi again folks.
I have a list of cells from lookups that result in this. these cells have ether equal too or vlookup results.
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>
What i would like to do is compare tch_2 cells to trx2 cells and if both have data then do nothing but if as in the case of tch_3 and trx3 there are blanks in tch_3 then another cell has an output text. unfortnately i can get a result for these BUT if both cells are blank i still get an output. it sees the lookups or equals as a content. I've tried Value and iferror but cant get to the state where no ouptut is given when both are blank
Hope this is clear folks and thanks in advance.
Carl
I have a list of cells from lookups that result in this. these cells have ether equal too or vlookup results.
TCH_2 | TCH_3 | TCH_4 | TRX2 | TRX3 | TRX4 | TRX5 | |
55 | 2 | 3 | |||||
48 | 8 | 9 | |||||
34 | 14 | 15 | |||||
78 | 20 | 21 | |||||
84 | 26 | 27 |
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>
What i would like to do is compare tch_2 cells to trx2 cells and if both have data then do nothing but if as in the case of tch_3 and trx3 there are blanks in tch_3 then another cell has an output text. unfortnately i can get a result for these BUT if both cells are blank i still get an output. it sees the lookups or equals as a content. I've tried Value and iferror but cant get to the state where no ouptut is given when both are blank
Hope this is clear folks and thanks in advance.
Carl