I have a table on sheet 1 that I am attempting to create access to via cell specific hyperlinks. On sheet 2 I have a data validation drop-down list with all data from the column one of this table & I have another data validation drop-down list with all the data from the first row. I want to populate a link to the intersecting cell based on these two options. For example if I go to sheet 2 and choose customer 3 and product 5 I want to be directed to (either by hyperlink or automatically) cell D6 in sheet 1. The actual table I am working with will require editing the information I am directed to so having it copied over based on my selection is not an option. Does anybody have any recommendations?
Attachments
Last edited: