On Tue, 14 Mar 2006 05:47:20 -0500, Den
wrote:


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

Hi Richard,

Also found the solution.

The problem was with ...ME...in the first place :-(((

The example I gave you in sheet2 col A

cell[2].images[0].image=../../../E:\My PICTURES\Fam/Friends\kat25.jpg

but the actual data a

cell[2].images[0].image=../../../E:/My PICTURES/Fam/Friends/kat25.jpg

no "\" at all

So what I did was to replace "\" by "/" in ...MATCH("\",MID(....

and the formula is working great


Again I'm so grateful to you Richard for your help. It gave me much
more then a solution to a problem. From now on I may be an advocate
who believes that anything is possible with Excel.

Some of my friends had tried to help me with the mixture of three
programs to do the job with no success. (Better to have new friends
:-))

This newsgroup will be my learning platform & look for your advises to
others.

Thank to the group

Den
Canada