Hi,

Is there a way to HLOOKUP a value from SheetB and display all the result of
that value in SheetA?

EG.
SheetA:
A1
Dust
Desk
Chair

Sheet2
Dust Desk Chair
D1 OY yu
d2 or yi
d3 os yt


in SHeetA, I need to HLOOKUP "Desk" and to display all the rows in SHeet2,
the result should be
OY
or
os
in rows...

PLease let me know how do I get that???


THank you very very much in advanced.


//GK