Named ranges set by search return

P

penc

I'm using hyperlinks to named ranges and would like to be
able to set the named ranges dynamically for maintenance
purposes. I previously was asking about VLOOKUP with
multiple row returns.

Worksht1 has the general data, worksht2 has the detailed.
I name the range and then link to the data in worksht2.
This will be a big maintenance job without dynamic setting.

Any ideas?
 

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

Similar Threads

Need formulas for searching for a value in a table and returning row/column name 7
Setting a range in a named range 3
Dsum and Dmax with structured references 1
Extract name, address and ph# 8
trouble with (complicated) vlookup searching another workbook 2
a data validation list that contains a list of named ranges - not alist from a named range 1
Named Ranges set by search returns? 0
Links to Dynamic Named Range = Problem 8

Top