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
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