What is wrong with this formula

BrendonL

Hi,

Im am trying to use this IF statement to check if the rows of 1 sheet have the same sections as the row on my current sheet and if it is true we return true. However, I cant seem to get this forumla to work. I was trying to add a @ row to the reference to the other sheet but it gives me an error. but if i just reference the column from the other sheet, it also gives me an error.

Mark.poole

@BrendonL

Hi. So the issue your if statement is comparing an entire Range to the section@row. Refrences wont work that way. Instead try using a count if statement. IF(COUNTIF({Refrence from other sheet}, = Section@row) >0,"True","False")

This will count every row you have that matches that particular range "Section@row" If it finds any rows that match it will flag it as true.