Hyperlink after IF,MATCH &HLOOKUP funtcion

[michelcr7]

Hi guys,

In Sheet1 i have the following formula which displays the value(hyperlink to website or distrubution list) from Sheet2.

=IF(ISNA(MATCH($A77,'MM Shelf'!$F$7:$AG$7,0)),"",HLOOKUP($A77,'MM Shelf'!$F$7:$AG$27,L$1,0))

This works correctly but how do i get to appear as a hyperlink so once clicked it goes to the specific cell(or even directly to the website or distrubution list) it got from the IF function on Sheet2?

Best regards,
Michel

 

[philwojo]

Have you tried surrounding it by the HYPERLINK formula?

 

[michelcr7]

You mean:

=HYPERLINK(IF(ISNA(MATCH($A77,'MM Shelf'!$F$7:$AG$7,0)),"",HLOOKUP($A77,'MM Shelf'!$F$7:$AG$27,L$1,0)))

I recevies :"Cannot open the specified file"

Unfortunatelly doesn't work. Problem is that IF functions return only values from another sheet, not the hyperlink assign to value.

 

[philwojo]

Ok, maybe I'm not following what your IF function is doing then, or maybe my understanding of the Hyperlink function is wrong. Maybe another use has an idea for you on this one then, sorry.

 

[michelcr7]

Maybe I was not clear. Sorry for that.

Generally my if function match's specific condition-example:

A: https.www.boc
B: https.ww.cic

But function IF brake hyperlink and receives only value 'https.www.boc.

Any idea hot to fix it?

 

[michelcr7]

Hi Guys,

Any ideas?