Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

The following array formula gives as output the name of a cell

{="'Sheet 2'!H"&MATCH(C1&D$39,'Sheet 2'!A:A&'Sheet 2'!C:C,0)}

Where C1 and D$39 are an array variable concatenated out of two

different columns and Sheet 2 is a sheet I'm searching for that

combination of variables (i.e. a payment by a certain payer on a

certain date). The result of this particular formula is 'Sheet 2'!

H842 because that particular combination of values occurs in row 842.

I want to put the cursor into 'Sheet 2'!H842 with a hyperlink, or

something like a hyperlink, so I can put a column of "Click to go to

this payment" links next to a pivot table, or better yet inside the

pivot table itself.

But my attempts to use this formula as a cell reference aren't

working, perhaps because arrays don't work in hyperlink cell

references.

So how do I do it?

Didn't find what you were looking for?
Find more on Using an array formula as a hyperlink cell reference
Or get search suggestion and latest updates.

Related Topics:

- formula returns to multiple cells, without Array object?
- Copy Value produced by formula in cell C3 to cell D3
- Ctrl+Shift+Arrow Fails To Select Cells When Used in Formula Bar
- how are cell coordinates referenced on a clicked cell
- clearing cells value without deleting the formula I've made in cell from excel formula , HOW?
- cells containing formula that refer to user-defined VBA function
- VBA code to add values in two cells which have formulas
- Array Formula
- VBA or array formula?
- update cell based on hyperlink selected
- Copying current cell's value to another cell
- VBA Array - return value to a cell
- Editing cell references w/ VBA
- adds =round(cell references,5) to allocate the calculation to 5 places
- Hidden Cells Reference Problem
- Declaring a Cell reference as a variable
- Cell referencing
- Cell reference/pane errors
- Formula using range name in VBA code
- Copy cell contents to same cell on different worksheet if contains
- Finding and replacing the cell next to a cell with a certain string
- Update a cell based on a DDE updated cell value
- active cell no longer advances to cell below
- How to copy automaticly (..using VB) my active cell after cell entry in different cell in anoth
- A Paragraphs in one cells --> convert into a line in per cells