INDEX MATCH HYPERLINK CELL SPECIFIC

[JTNuke]

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?

 

[Fluff]

How about

=HYPERLINK("#"&CELL("address",INDEX(Sheet1!B2:F6,MATCH(A2,Sheet1!A2:A6,0),MATCH(B2, Sheet1!B1:F1,0))),"click me")

 

[JTNuke]

How about

=HYPERLINK("#"&CELL("address",INDEX(Sheet1!B2:F6,MATCH(A2,Sheet1!A2:A6,0),MATCH(B2, Sheet1!B1:F1,0))),"click me")

This worked perfectly! Thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback.