How do Match another cell

Samuel Dowdy Jr.

=MATCH([Purchase Order No.]@row, [Invoice Review Status]@row, "Approved")

Paul Newcome

Try this...

=IF([Invoice Review Status]@row = "Approved", [Purchase Order No.]@row)

Paul Newcome

What exactly are you trying to accomplish?

Samuel Dowdy Jr.

I want to match another cell only when the status cell is approved.

Paul Newcome

Try this...

=IF([Invoice Review Status]@row = "Approved", [Purchase Order No.]@row)