Question with using IFERROR(INDEX(COLLECT formula

I am trying to use the index/collect statement to pull the job number based off of the PO # and the Part #. If there is nothing, then I want it to leave the cell blank. However, I get an "#INCORRECT ARGUMENT SET" error.

This is the formula:

=IFERROR(INDEX(COLLECT({Job #}, {PO #}, [PO Number]@row, {Part #}, [Part Number]@row, "")))

Am I getting an error due to the "#" sign used for the headers on the reference sheet?

Thanks!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!