vlookup - return a range?

[odie]

I would like to define a named range = vlookup("2", range1,3,false).

Whenever I try this, vlookup only returns the first match in range1, not the
other match occurances. I have tried entering as an array formula but it
only returns the first match. I admit I may be confused between ranges and
arrays.

Could someone please help? thanks...

 

[Alan Beban]

And I'm confused between ranges and values. Could you post a brief
illustration of what your data might be and what result you want?

Alan Beban

 

[Dave Peterson]

=Vlookup() only returns one value.

I'm guessing you have a table like

a 1 2
a 1 3
a 3 4
b 1 2
c 1 2

and if you did =vlookup("a",a1:c5,3,false), you thought you could get 3,4,5
returned.

Here's a link to a thread with some alternatives:
http://groups.google.com/[email protected]

 

[Alan Beban]

And here's another for the VLookups function in the freely downloadable
file:

http://home.pacbell.net/beban

Alan Beban