Match/Index
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
-
I am confused about what you are trying to do with all those INDEX/MATCH... Also, your IFERRORs seems to be in the wrong place if you are imbedding it it should look like:
=IFERROR(FORMULA, IFERROR(FORMULA, IFERROR(...)))
Or something similar to that.
-
I want to populate the buyer name which is depending on an item which is spread all across 5 different sheet and if have the buyer name then populate the name, if not found just leave the column blank. Can you help to suggest the correct way to do it?
-
This would be the proper syntax:
=IFERROR(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))), "")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!