Hi All,
A formula which i received from the advisor is appended below and it is working perfectly.
=IF(COUNTIF($G$3:$G$12,B5)>0,$H$3,IF(COUNTIF($J$3:$J$12,B5)>0,$K$3,IF(COUNTIF($M$3:$M$12,B5)>0,$N$3,IF(COUNTIF($P$3:$P$12,B5)>0,$Q$3,""))))
I have a code as well, with this workbook which is reasonably complex_ but again working magically perfect- meant for other purpose.
As per this code if I enter certain input in sheet 1, it will give relative references in Sheet 2 cells in Row 1. Say it gives references in A1, B1 and C1 in sheet 2.
The above formula is expected to enter in D1 in Sheet 2.
Now the issue is, if I revert the entry which i made in Sheet 1 to its earlier value, as per code it will replace the Row 1 with fresh Row 1 in Sheet 2, with empty cells.
Though the code works as intended, my formula in D1 is also getting deleted with empty cell.
Is there any simple fix for this issue, I want the above formula to be there in same cell D1 even after the row is being replaced with new one.
Thanks in Advance
A formula which i received from the advisor is appended below and it is working perfectly.
=IF(COUNTIF($G$3:$G$12,B5)>0,$H$3,IF(COUNTIF($J$3:$J$12,B5)>0,$K$3,IF(COUNTIF($M$3:$M$12,B5)>0,$N$3,IF(COUNTIF($P$3:$P$12,B5)>0,$Q$3,""))))
I have a code as well, with this workbook which is reasonably complex_ but again working magically perfect- meant for other purpose.
As per this code if I enter certain input in sheet 1, it will give relative references in Sheet 2 cells in Row 1. Say it gives references in A1, B1 and C1 in sheet 2.
The above formula is expected to enter in D1 in Sheet 2.
Now the issue is, if I revert the entry which i made in Sheet 1 to its earlier value, as per code it will replace the Row 1 with fresh Row 1 in Sheet 2, with empty cells.
Though the code works as intended, my formula in D1 is also getting deleted with empty cell.
Is there any simple fix for this issue, I want the above formula to be there in same cell D1 even after the row is being replaced with new one.
Thanks in Advance