Results 1 to 4 of 4

Limiting Number of Lookups for XML

Threaded View

  1. #1
    Registered User
    Join Date
    05-29-2012
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    31

    Unhappy Limiting Number of Lookups for XML

    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!
    Last edited by fansoffloyd; 06-06-2013 at 12:59 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1