Results 1 to 5 of 5

Help with Formula Please!! (IFERROR/INDEX)

Threaded View

  1. #1
    Registered User
    Join Date
    04-15-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    10

    Angry Help with Formula Please!! (IFERROR/INDEX)

    Hi,

    Have problems with the attached file, i'm trying to create a sheet with merged data from different sheets based on a primary key field (url).

    I want the formula to search the original sheet "OSE" and pull data where the url matches that of the sheet "Merge"

    I have partially completed the formula:

    =IFERROR(INDEX(OSE!$B$2:$B$999,SMALL(IF(OSE!$A$3:$A$999=A3,ROW($A$3:$A$999)-ROW($E$3)+1,5E+100),ROW(AX1))),"")

    but i think some of the formula is redundant and not used, the only thing it does not do is find pull back info for url's that are not on the same row. From the attached you can see the only value that gets pulled back is that in the sheet "Merge" B5 - This did work for this one cell but when i trimmed down the data so i could include it as a sample it stopped working.

    Any help is much appreciated.
    Attached Files Attached Files

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