0

I was querying a hyperlink row from one sheet to another using this formula:

=QUERY(Data!A2:$F, "SELECT E WHERE C = 'fragment' ")

However I discovered that it copying only text but not the whole thing. After some research I found out that I can solve that problem by using this:

=ARRAYFORMULA(VLOOKUP(QUERY(Data!A2:$F, "SELECT E WHERE C = 'fragment' "),Data!E:E,1,FALSE))

However the problem now I have is that formula put same value on each cell

1 Answer 1

1

Use filter() to keep hyperlinks, like this:

=filter(Data!E2:E, Data!C2:C = "fragment")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.