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