Hey everyone,
I currently have the below Index / Match formula down, but as I'm automating Print Setup it keeps picking up all the cells with formulas and not just the populated ones as I want. I was hoping if someone could help me out in where I could use the below formula based on a condition.
=IF(ISNA(INDEX(table2,MATCH(B8,table3,0),MATCH($A$5,GPOTABLE1,0))),"",INDEX(table2,MATCH(B8,table3,0),MATCH($A$5,GPOTABLE1,0)))
The formula resides in all of A7:A. I would like to activate the formula if Column B (B7:B) is populated. Column B could have 1 row or it could have 5,000.
Thanks everyone for the help. Let me know if anyone has any questions or if I need to clarify anything.
I currently have the below Index / Match formula down, but as I'm automating Print Setup it keeps picking up all the cells with formulas and not just the populated ones as I want. I was hoping if someone could help me out in where I could use the below formula based on a condition.
=IF(ISNA(INDEX(table2,MATCH(B8,table3,0),MATCH($A$5,GPOTABLE1,0))),"",INDEX(table2,MATCH(B8,table3,0),MATCH($A$5,GPOTABLE1,0)))
The formula resides in all of A7:A. I would like to activate the formula if Column B (B7:B) is populated. Column B could have 1 row or it could have 5,000.
Thanks everyone for the help. Let me know if anyone has any questions or if I need to clarify anything.
