Excel Get current row in from sumif statement

Im using Excel 2010 and have a datasheet with multiple tabs, this is the current sumif function that i am using

 =IF(SUMIF('Master Data'!$J$2:$J$200,'Resource View (2)'!B22,'Master Data'!$W$2:$W$200)>0,Current_row_different column, "")

Basically I find some rows in the other sheet that have a value of 1 i then want to use these rows that have a value of 1 but use a different column within that row to populate the true condition.

So say for instance row 4 contains a 1 at column A I then want to stay on row 4 but get the value of column B for the true condition.

Is this possible?

Any suggestions much appreciated

Thanks in advance.