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

You need to take one step backwards.
First make sure the argument to the =HYPERLINK() function is a good reference.
--
Gary''s Student - gsnu200856


"rel" wrote:

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