IFERROR and MATCH

Hello,

I am trying to say: **On 2024 Conferences Sheet**

If project name on sheet "PO List Service and HR" matches the conference name on "2024 Conferences", input the PO number from "PO List Service and HR".

This is currently what I have:

=IFERROR({PO list service and HR Range 1}, MATCH([Conference Name]@row, {PO list service and HR Range 2}, 0))

The first range is the project name and the second range is the PO number.

Thank you in advance!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!