Formula - INDEX/MATCH
UPDATE: =IFERROR(INDEX({Issues/Incidents Tracker Range 2}, MATCH([Project # / Request #]@row, {Issues/Incidents Tracker Range 3}, 0)), " ")
I forgot about IFERROR
I had a quick question about a formula. I am attempting to pull in data to reference another sheet. In my formula, I have attempted to add in “” and false (in variations) at the end to ensure I do not receive a #NO MATCH output in the cell but neither of those worked. I have attempted to use the VLOOKUP as well still #NO MATCH. Not sure what I am missing or how to get a blank cell except for the matching items to pull in the Incident #.
=INDEX({Issues/Incidents Tracker Range 2}, MATCH([Project # / Request #]@row, {Issues/Incidents Tracker Range 3}, 0))
Adriane
Best Answer
-
Hello @Bassam.M Khalil - I received an Incorrect Argument error in the cell when using that formula. However, I double-checked on my above formula for the 'IFERROR' and that one ended up working for my needs. Thank you!
=IFERROR(INDEX({Issues/Incidents Tracker Range 2}, MATCH([Project # / Request #]@row, {Issues/Incidents Tracker Range 3}, 0)), " ")
Adriane
Answers
-
Hi @Adriane Price
Hope you are fine, did you try to use the following:
=IF(IF(ISBLANK(INDEX({Issues/Incidents Tracker Range 2}, MATCH([Project # / Request #]@row, {Issues/Incidents Tracker Range 3}, 0)),"", INDEX({Issues/Incidents Tracker Range 2}, MATCH([Project # / Request #]@row, {Issues/Incidents Tracker Range 3}, 0)), " ")))
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hello @Bassam.M Khalil - I received an Incorrect Argument error in the cell when using that formula. However, I double-checked on my above formula for the 'IFERROR' and that one ended up working for my needs. Thank you!
=IFERROR(INDEX({Issues/Incidents Tracker Range 2}, MATCH([Project # / Request #]@row, {Issues/Incidents Tracker Range 3}, 0)), " ")
Adriane
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!