Can Index Match pull over a hyperlink in a Children row?

I'm using this formula to pull info from one sheet to another based on an Asset #. One of the fields I'm pulling has a hyperlink in it. This seems to work on some rows but not others. Here's the formula:

=INDEX({Asset Catalog Range 3}, MATCH([Asset #]@row, {Asset Catalog Asset #}, 0))

This formula woks for this row (see pic).

This formula doesn't bring back anything for the Children row in Step 1

=INDEX({Process Steps Step 1}, MATCH([Asset Type Steps]@row, {Process Steps Asset Item}, 0))

Screen Shot 2021-08-25 at 10.57.22 AM.png

Any ideas?

Find more posts tagged with

Accepted answers

Paul Newcome

It looks like it may be because you have a "custom text" for the second whereas the row it is working on is just a straight URL. Have you tested yet to see if maybe that is a commonality?

All comments

Paul Newcome

Are you able to provide screenshots of the source sheet as well?

Jeana

Of course,

Here is the source sheet. Based on a INDEX of "Item" and a MATCH I want to pull back the link in Step 1 basically. It pulls back the information but not as a link.

Screen Shot 2021-08-25 at 11.14.48 AM.png

Here is destination sheet pic.

Screen Shot 2021-08-25 at 11.18.58 AM.png

Paul Newcome

It looks like it may be because you have a "custom text" for the second whereas the row it is working on is just a straight URL. Have you tested yet to see if maybe that is a commonality?

Jeana

That was it!! I'll try a helper column to see if I can get this to be more user friendly.

Thanks Paul!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.