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