I am trying to make a function that repeats in each row of a column that fetches the URL in the first column, does an xpath query and gets an image.

Currently its all working other than the fact it always fetches the URL in A1, not the value in column A relative to the row. The result is that each row, column B has the same image repeated (the URL in A1).

=ArrayFormula(if(A1:A<>"", ArrayFormula(image(importxml(INDIRECT("C[-1]", false),"//*[@id='J-dcv-image-trigger']/@src"))),""))


Your Answer

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