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...