Better way to write this nested formula?

Is there a better way to write this formula?
=indexrow(filter(M_Approvers,"M_Approvers[Project]=%","CFO"),1)[Approver]

Background:
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!

2 Likes

Glad I could help :grinning:

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