Bring data from sheet B to sheet A based on criteria in sheet B


I have 2 sheets set up, I need data from one sheet going to another based on a value in a cell on sheet B, if this condition is met I need 'Project title' to be taken from sheet B to the formula location on Sheet A. The condition is that the cell in question is 0 if its anything else nothing needs to happen.

I have tried multiple ways of VLOOKUP, INDEX, and IF combinations but I'm not getting anything back other than errors so any help would be appreciated as I'm 5 seconds away from accusing Smarthsheets of conspiring against me. Which seems unfair as its me missing something!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!