Formula - INDEX/MATCH

Adriane Price
Adriane Price ✭✭✭✭✭✭
edited 03/03/21 in Formulas and Functions

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

  • Adriane Price
    Adriane Price ✭✭✭✭✭✭
    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

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    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)), " ")))

    PMP Certified

    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"

  • Adriane Price
    Adriane Price ✭✭✭✭✭✭
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!