extract lookup image with named range with index and match not working

[JEAN1972]

I have a workbook with a sheet named split .

What I am trying to do is extracting image from sheet split .from column B to column J .

Columns I2 represent the criteria of the code number for extracting image in column J2.

I have created a named range KOO1_ but it is not working

=INDEX(split!$B$3:$B$174,MATCH(split!$I6,split!$A$3:$A$174,0))

[kyleboyd]

I think your problem is the dynamic nature of the match function. The formula doesn't know what cell the picture is in to calc your named range formula. If you change it to split!$I$6 it works, but just for that row.

So I think your two options are to create a specific named range for each row, or to use VBA.