IFERROR and MATCH

Alexsys

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!

Paul Newcome

You need an INDEX function to tell the formula to pull, and you need to finish out the IFERROR function.

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

Alexsys

@Paul Newcome great got it thank you. I just realized I need to add another condition to the above. I want it to then say at the end to do all of that if (PO list service and HR range 3) is "open".

Alexsys

@Paul Newcome Sorry to bother you, don't know if you saw my additional comment. Thank you!

Paul Newcome

You would use an IF statement with another INDEX/MATCH.

=IF(INDEX/MATCH range 3 = "Open", INDEX/MATCH range 1)