Linked Named Ranges

D

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
 
D

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
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top