On Mon, 13 Mar 2006 14:07:04 +0000, Richard Buttrey
wrote:


It should have read

=LEFT(A1,FIND("E:",A1)-1)&VLOOKUP((RIGHT(A1,MATCH("\",MID(A1,LEN(A1)-ROW($1:$255),1),0))),Sheet1!$A$1:$B$5,2,FALSE)

If you paste that you will probably need to immediately edit it with
F2, and then hold the CTRL and Shift keys down whilst you Enter it.
You should end up with curly brackets {....} at either end of the
formula, which will confirm that it is correctly entered as an array
formula.

Rgds


Found the problem but not the solution ;-(

I took the example of line
kat25.jpg E:\My PICTURES\2004\20040326_1698.jpg

and also the line on sheet2 col A
cell[2].images[0].image=../../../E:\My PICTURES\Fam/Friends\kat25.jpg

and paste it at the end of my complete worksheet that didn't work
sorted sheet1 on column A and got the right result in sheet2 col B
for that added line

For some reason it doesn't work on the other lines and the problem is
with the last argument in the RIGHT function.

the working solution gives: ...&VLOOKUP((right(cell....kat25.jpg;9))
instead of the 9 or any other figure we get #N/A in all other lines

if I'm not mistaken it would be the MATCH function that gives this
result.


Den