Hyperlink function not going anywhere

R

rel

I am using Excel 2007, but sharing document with 2003 users.

I have a master list of ingredients on SHEET1. I have inserted hyperlinks to
MSDS files located on our server. Those links work fine.
On SHEET2 I have a Product's Ingredient list. I am using a combonation of
"hyperlink", "index", & "match" to have the formula sheet lookup the
hyperlink for the MSDS on the master ingredient sheet.

Here are the Defined Names;
A1:N1 "Categories", A1:A203 "SKU", A1:N203 "DocLook"

The Formula;
=hyperlink(index(DocLook,match($n$1,Categories,0),match($a2,SKU,0))"MSDS")


BUT the resulting Hyperlink value goes nowhere :( Please help!!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top