kanuvas wrote:
Hi all

If i have a value i want to lookup against anouther table and print out
something in the column next to it i would use a vlookup. However in
this instance there is a number of matchs for the vlookup and i want to
print all the values assosiated with it.

EG

nme attribute
a yyy
a xxx
a juy
b kfh
b hrhr
c ieue

So i want to lookup b. It prints out values kfh and hrhr in two
different cells.

Any help would be appreciated.

Thx


If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

=VLookups("b",a1:b6,2), array entered into a two-cell column

Alan Beban