Match/Index

Options

I have the formula below and i want the results as if no name can be found, let the it blank. The formula i have below is giving me Incorrect argument. Pls help in this. Thanks and I am a beginner for Smartsheet


=IFERROR(IFERROR(IFERROR(INDEX({Buyer2}, MATCH(Combine@row, {Combine2}, 0), " "), INDEX({Buyer3}, MATCH(Combine@row, {Combine3}, 0)), " "), INDEX({Buyer4}, MATCH(Combine@row, {Combine4}, 0)), " "), INDEX({Buyer5}, MATCH(Combine@row, {Combine5}, 0)), " ")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!