I have a sheet where the data shown is based on combobox selections. The values are calculated using a formula like this:
Q61 is a range in a different sheet: 'Data'!$AO$6:$AO$104000 SUMPRODUCT matches four other criteria based on combobox selections.
The formula should calculate the row in the range and return a value. Is there a way in VBA to determine the address found by that formula. It should be something like 'Data'!$AO$90. I must get the address because I am looking for the hyperlink in that address.
The INDEX formula correctly returns the value in 'Data'!$AO$90. I want to put back the hyperlink.
This is an image of the sheet. Each value is calculated using an INDEX formula as shown above. A few values should have hyperlinks. I must get the original address in the 'Data'! sheet to put them back with VBA whenever the user makes a new selection.