you could use datafilterautofilterfilter on b and then print

--
Don Guillett
SalesAid Software

"kanuvas" wrote in
message ...

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


--
kanuvas
------------------------------------------------------------------------
kanuvas's Profile:
http://www.excelforum.com/member.php...o&userid=27911
View this thread: http://www.excelforum.com/showthread...hreadid=492732