Help with Formula Please!! (IFERROR/INDEX)

**leowyatt** · 05-24-2013, 04:36 AM

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.

**leowyatt** · 05-28-2013, 04:23 AM

Pretty Please...

**Fotis1991** · 05-28-2013, 04:59 AM

Perhaps....in B3 this ARRAY formula. Copy down and across.

IFERROR(INDEX(OSE!B$2:B$100,SMALL(IF(OSE!$A$2:$A$100=$A3,ROW(OSE!B$2:B$100)-1),ROW(OSE!B1))),"")

**leowyatt** · 05-28-2013, 05:09 AM

Hi,

This works but only for rows where the corresponding URL is on the same line (B3 and B5) - It just gives a blank for the rest. This is the stage i had originally got to put when trimming the example to 100 rows it broke it.

Many thanks for your help though... Still stumped!!