Reference 2 columns from a separate sheet

Kendra P

Hello - I am trying to reference and Match 2 columns from a separate sheet. I am using ISBLANK. Here is the formula below that I am getting Unparseable

=IF(ISBLANK([Role]@row, "0", {Business Rule - CSR Indicator},{MATCH[Role]@row,{Business Rule - CSR Role}})

Paul Newcome

What is the desired outcome of this formula? What exactly are you trying to accomplish?

Kendra P

In the column of the formula I am trying to retrieve if the role column is blank then I need it to return a 0 but if it has text in it I need it to reference a separate sheet and two separate columns within that sheet. One column (Business Rule - CSR Indicator) returns a 1 or 0 and I need that to match what the other column (Business Rule - CSR Role) has entered which are different roles that answer the question of the Indicator column. Does that make sense?

Paul Newcome

Are you able to provide some screenshots for reference?