Better way to write this nested formula?

Is there a better way to write this formula?

I'm trying to write this cell contact with the project name of "CFO"

And write it to POs[Approver]

It works, but I don't like it.

How about this:

=FINDROW(M_Approvers, "M_Approvers[Project]=%", "CFO")[Approver]

1 Like

That did it! Thanks Isaiah!


Glad I could help :grinning:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.