Hello,
I am actually using Googledocs for this one but I believe the answer is simple enough to transfer over.
I am doing an importxml function which is as follows
=INDEX(ImportXML(B$1,A$1),2)
B1 = DrudgeReport.com
A1 = //tt/b/a
This returns the second result, as I matched the Index with the number 2 at the end. My questions is, how do I get results 2-5 to return?
I have tried :
=INDEX(ImportXML(B$1,A$1),2&5)
=INDEX(ImportXML(B$1,A$1),2;5)
=INDEX(ImportXML(B$1,A$1),2-5)
Any ideas?
I can get the results by inputing them one at a time as follows
=INDEX(ImportXML(B$1,A$1),2)
=INDEX(ImportXML(B$1,A$1),3)
=INDEX(ImportXML(B$1,A$1),4)
=INDEX(ImportXML(B$1,A$1),5)
But I want it to do it in the same formula. Please help!
Bookmarks