Hi all!
I'm hoping someone has a simple solution that can save me a lot of time here. I have a formula that I need to copy and paste down 200 ROWS, and need the below COLUMNS to increment. (In bold)
=IF(INDEX(Main!$R:$R,MATCH(1,(Material!$B$1=Main!$A:$A)*(Material!B$4=Main!$C:$C),))=0,"",INDEX(Main!$R:$R,MATCH(1,(Material!$B$1=Main!$A:$A)*(Material!B$4=Main!$C:$C),)))
I also need to copy this formula across 10 columns, which is why they are surrounded by $'s. Without the $'s, when I copy the formula down, the columns do not increment, requiring me to manually update them.
I did a google search, and it seems like the column function [might] help here, but I'm not entirely sure. If anyone could provide some guidance, I'd greatly appreciate it!
Thanks all!
I'm hoping someone has a simple solution that can save me a lot of time here. I have a formula that I need to copy and paste down 200 ROWS, and need the below COLUMNS to increment. (In bold)
=IF(INDEX(Main!$R:$R,MATCH(1,(Material!$B$1=Main!$A:$A)*(Material!B$4=Main!$C:$C),))=0,"",INDEX(Main!$R:$R,MATCH(1,(Material!$B$1=Main!$A:$A)*(Material!B$4=Main!$C:$C),)))
I also need to copy this formula across 10 columns, which is why they are surrounded by $'s. Without the $'s, when I copy the formula down, the columns do not increment, requiring me to manually update them.
I did a google search, and it seems like the column function [might] help here, but I'm not entirely sure. If anyone could provide some guidance, I'd greatly appreciate it!
Thanks all!