Trying to anchor formula to specific row

Alan Meshaw

SS Question.gif

Hi, I have entered this and it works:

=IF(FIND([SOP Required Group]1, [SOP Required Group]@row) > 0, "Y", "N")

but if I want to anchor to Row 1, I get an #unparseable error:

=IF(FIND(SOP Required Group1, [SOP Required Group]@row) > 0, "Y", "N")

What am I missing?

Alan Meshaw

Sorry, I actually answered this myself, but if anyone has a similar problem, here is the solution:

=IF(FIND($[SOP Required Group]$1, [SOP Required Group]@row) > 0, "Y", "N")

Alan Meshaw

Sorry, I actually answered this myself, but if anyone has a similar problem, here is the solution:

=IF(FIND($[SOP Required Group]$1, [SOP Required Group]@row) > 0, "Y", "N")