"learning" formula

jberry216 · Feb 21st, 2002, 01:34 PM

I have a column of cells which are range names. I am trying to run an intersect routine. I want the Intersect formula to "read" the contents of the range name cells, to populate the formula. Any ideas?

Mark W. · Feb 21st, 2002, 01:37 PM

=INDIRECT(A1) where A1 contains a text representation of a defined range name. BTW the formula, =INDIRECT("range1") INDIRECT("range2"), will return the intersection value(s) of defined names 'range1' and 'range2'.

[ This Message was edited by: Mark W. on 2002-02-21 12:46 ]

jberry216 · Feb 21st, 2002, 02:29 PM

WOOHOO! Thanks. Works great.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 21st, 2002, 01:34 PM	#1
jberry216 New Member Join Date: Feb 2002 Location: Houston, TX Posts: 14	I have a column of cells which are range names. I am trying to run an intersect routine. I want the Intersect formula to "read" the contents of the range name cells, to populate the formula. Any ideas?

Feb 21st, 2002, 01:37 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	=INDIRECT(A1) where A1 contains a text representation of a defined range name. BTW the formula, =INDIRECT("range1") INDIRECT("range2"), will return the intersection value(s) of defined names 'range1' and 'range2'. [ This Message was edited by: Mark W. on 2002-02-21 12:46 ]

Feb 21st, 2002, 02:29 PM	#3
jberry216 New Member Join Date: Feb 2002 Location: Houston, TX Posts: 14	WOOHOO! Thanks. Works great.