Match Cell Formula

taylorstokes

IF({Project Name} = [Profit Center]@row, {Division}

I am trying to say if the two project names match, populate the division cell.

Valdeir Faria F.

Hi Taylor,

The way I understand your formula is that if the Project Name is the same as the Profit Center in the row, then the Division cell is populated.

First, are you typing this formula into the Division cell? If so, where you typed {Division} is actually the 'value item' if your logical expression is true. Therefore, your formula should look like this:

=IF([Project Name]@row = [Profit Center]@row, "value_if_true")

You would place the word or boolean you want "value_if_true" to populate in the Division cell.

Let me know if that helps!