Named Ranges+VLOOKUP+Arrays=Question

I have a list of values and from that list I need to define a dynamic named range based on criteria. For example, I need to define a named range for all values in a particular column that begin with 001. It must be dynamic as well as to account for new values added to the list.

It seems like one way to do this could utilize VLOOKUP. But since VLOOKUP returns one value, it would have to be an array application and I don't know if/how to accomplish that.

Any guidance would be greatly appreciated.

Thanks in advance.

I figured out a way myself. Here it is for future ref.

It works with a sorted list and selects a range of cells with a common flag defined in an adjacent column.

OFFSET is used in combination with MATCH and COUNTIF.

e.g.

=OFFSET(Constants!$D$3,MATCH(Variables!$E$7,Constants!$D:$D,0)-3,1,COUNTIF(Constants!$D:$D,Variables!$E$7),1)

Match determines the starting point for the range and COUNTIF is used to determine the end point. Works nice.