Go to hyperlink within excel workbook

by user961949   Last Updated November 09, 2018 01:01 AM - source

What excel formula can I use to launch a hyperlink, go to the worksheet the hyper link takes you to and extract specific information into a table? e.g worksheet 1 has a directory list with specific codes - if my cell equals to one of those codes, can my table populate with specific information)

Related Questions

Excel 2016 - Any suggestions on functions?

Updated November 10, 2017 00:01 AM