Pull data in an column from master sheet if a check box is checked
I have a master sheet called "a_Portfolio Master" and a new sheet called "Country". The portfolio master has many lines.
Column 3 of the master sheet contains a checkbox. When the checkbox in column 3 of the master sheet is checked, I would like to copy what is in column 2 of the master sheet into column 2 of the new sheet and do that for every row of the master sheet. If the checkbox is not checked in column 3 then column 2 of the new sheet should say "no match".
Thanks a lot!
Help Article Resources
Check out the Formula Handbook template!