Linked Named Ranges

[DaveMoore]

Hi. I have created a formula that links with named ranges in other
workbooks.
The formula currently reads -
=VLOOKUP($A14,Book2!table,3,FALSE)

Where the formula refers to the named range in the table array I would
like to point to a cell in the active worksheet for the named range.

In the above example something like
=VLOOKUP($A14,Book2!"$C$3",3,FALSE)

Is this possible?

Many Thanks for any suggestions,
Dave Moore

 

[Don Guillett Excel MVP]

Hi. I have created a formula that links with named ranges in other
workbooks.
The formula currently reads -
=VLOOKUP($A14,Book2!table,3,FALSE)

Where the formula refers to the named range in the table array I would
like to point to a cell in the active worksheet for the named range.

In the above example something like
=VLOOKUP($A14,Book2!"$C$3",3,FALSE)

Is this possible?

Many Thanks for any suggestions,
Dave Moore

Right click sheet tab in destination file>copy/paste this>modify to
suit where j3:j4 contains the typed in name of your named range.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Or _
Intersect(Target, Range("j3:j4")) Is Nothing Then Exit Sub
Range("k2").Formula = "=VLOOKUP(1,book2!" & Target & ",2,0)"
End Sub

 

[Don Guillett Excel MVP]

Right click sheet tab in destination file>copy/paste this>modify to
suit where j3:j4 contains the typed in name of your named range.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Or _
Intersect(Target, Range("j3:j4")) Is Nothing Then Exit Sub
Range("k2").Formula = "=VLOOKUP(1,book2!" & Target & ",2,0)"
End Sub

Right click sheet tab in destination file>VIEW CODE>copy/paste
this>modify to