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

Jeana

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

Any ideas?

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?

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.

Here is destination sheet pic.

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. 👍️