Hi Boardmembers
I am hoping someone can guide me.
I have an IF statement that looks to another reference worksheet tab in the same workbook. I want to drag the IF statement down, but instead of looking at the next concurrent reference cell, I want to look at every 6th cell in the reference worksheet.
Can this be achieved please?
Here is an example of the formula I have....
=IF(OR('Current and Pending Projects'!A222="",'Current and Pending Projects'!A222="Enter Client Name Here"),"",'Current and Pending Projects'!A222)
When I drag down, I want the formula to look at A228, then next line A234, then A240 etc etc
Thank you in advance
I am hoping someone can guide me.
I have an IF statement that looks to another reference worksheet tab in the same workbook. I want to drag the IF statement down, but instead of looking at the next concurrent reference cell, I want to look at every 6th cell in the reference worksheet.
Can this be achieved please?
Here is an example of the formula I have....
=IF(OR('Current and Pending Projects'!A222="",'Current and Pending Projects'!A222="Enter Client Name Here"),"",'Current and Pending Projects'!A222)
When I drag down, I want the formula to look at A228, then next line A234, then A240 etc etc
Thank you in advance