INDEX MATCH showing #NO MATCH when there is one

I am trying to reference another sheet. The column I am trying to match is the Primary column that has hyperlinks and I am trying to match the display text. Here is my formula

=INDEX({Project Intake Sheet Range 1}, MATCH(Links@row, {Project Intake Sheet Range 5}, 0))

Range 1 is the primary column for the display text of the reference sheet. Links@row is the text on my sheet for the data to display. Range 5 is the data that I want to pull. I can add screenshots to show, but was wondering if the Hyperlink is the issue here.


Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!