Having some problems with MATCH Function and cell formatting...

[Apocalypso]

Hi,

I’m totally new here so first of all I would like to apologize because of my English and say hello to all of you

Anyway, I’m currently learning how to properly use ‘MATCH Function’ and so far it works fine, I have kind of a data base and form that puling data from it based on the ID [=INDEX(Baza!$E$6:Baza!$E$777;MATCH($D3;Baza!$A$6:Baza!$A$777;0)) ] and the problem is that it doesn’t pull formatting of the cell, only value?

Also one cell contains the hyperlink but again it doesn’t work very well, for example if I link pdf file the MATCH brings only the name of the linked file, not the actual link...

Any hint? Is it possible to solve those problems?

Thanks in advance,
Teo

[wenqq3]

Anyway, I’m currently learning how to properly use ‘MATCH Function’ and so far it works fine, I have kind of a data base and form that puling data from it based on the ID [=INDEX(Baza!$E$6:Baza!$E$777;MATCH($D3;Baza!$A$6:Baza!$A$777;0)) ] and the problem is that it doesn’t pull formatting of the cell, only value?

Formula and Function only return value.Suggest: you can copy and paste the formatting.

Also one cell contains the hyperlink but again it doesn’t work very well, for example if I link pdf file the MATCH brings only the name of the linked file, not the actual link...

=Hyperlink(Your Match function)

[Apocalypso]

Formula and Function only return value.Suggest: you can copy and paste the formatting

Not really an option :/

=Hyperlink(Your Match function)

Not working unfortunately it looks like link now but clicking on it dose nothing...

Attachment 344112

Attachment 344113

By the way to show the picture? I mean is it possible to asign picture to certain cell in base and that match function pul it and show it in the form?

kind regards,
Teo

[wenqq3]

By the way to show the picture? I mean is it possible to asign picture to certain cell in base and that match function pul it and show it in the form?

I google and find this : http://www.jkp-ads.com/articles/showpicture00.asp
Is this what you want?

[wenqq3]

Not working unfortunately it looks like link now but clicking on it dose nothing...

How you want it be done? Can you upload sample file?

[Apocalypso]

How you want it be done? Can you upload sample file?

It is quite simple, in the 'base' I put hyperlink in the certain cell and when I click it, it opens photo or pdf file but when I try to pull that hyperlink from cell it just gives me name of the file not clickable link. As a matter of fact you are right, I'll make sample file.. give me a moment...

[Apocalypso]

Here it is, the problem is in the F9 cell on first page:
http://1drv.ms/1nI9UQD

[wenqq3]

F9 =HYPERLINK(INDEX(Baza!$C$7:$C$778,MATCH($E$5,Baza!$A$7:Baza!$A$778,0)))

try this

[Apocalypso]

the formula you typed contains an error...

[Apocalypso]

As for the part picture....

[Apocalypso]

the formula you typed contains an error...

Fixed it
F9 =HYPERLINK(INDEX(Baza!$C$7:$C$778,MATCH($E$5,Baza!$A$7:Baza!$A$778,0)))

It is supposed to be:
F9 =HYPERLINK(INDEX(Baza!$C$7:Baza!$C$778;MATCH($E$5;Baza!$A$7:Baza!$A$778;0)))


Thanks a lot, now I only need to solve picture problem....

[Apocalypso]

I try to make it like this by creating ShowPicD macro:

Please Login or Register  to view this content.

and now if I put something like formula below it works:
=ShowPicD("D:\00 Stampa\00 BAZA\LQ artwork\"&AE28&".png")

But if i put something like this, it doesn't...
=ShowPicD("D:\00 Stampa\00 BAZA\LQ artwork\"&INDEX(Baza!$AM$7:Baza!$AM$778;MATCH($E$5;Baza!$A$7:Baza!$A$778;0))&".png")

[wenqq3]

INDEX(Baza!$AM$7:Baza!$AM$778;MATCH($E$5;Baza!$A$7:Baza!$A$778;0)) <<--- can you make sure this outcome is same as the image name?

[FDibbins]

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

[Apocalypso]

10Q all, I solved the problem with picture in mean time and formatting as well...

10X again

Kind regards,
Teo