Try the below formula in SheetA Cell B1. Assuming you have values to be
looked up in A1 and subsequent rows..

=HLOOKUP($A$1,Sheet2!A1:Z100,2) to return 1st value

OR

=HLOOKUP($A$1,Sheet2!A1:Z100,COLUMN()) to return 1st value
copy the formula to the cells C1, D1 ,E1...

--
If this post helps click Yes
---------------
Jacob Skaria


"gktan" wrote:

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