Your formula on sheet1, A2 should be (change the $J$500 to match the bottom
right corner of your data on sht2):

=VLOOKUP($A1,sht2!$A$1:$J$500,column(),false)

Copy it over to the right as far as needed



"Greg" wrote:

I'm looking for a method to display rows of data from sht1 onto sht2. Sht2
cell a1 is my match. If column A on sht1 finds a match or matches, then
display the entire row on sht2 starting at a2.
I tried vlookup but only get the first row. Any suggestions would be
appreciated. Thanks in advance, Greg.