Formula - INDEX/MATCH

Adriane Price

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 Price

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