Hi,

And by search window you mean AutoFilter? If so then set up a series of
=VLOOKUP($A1,$A5:$J100,COLUMN(),False)
enter this in B1 and then copy it to C1:J1)

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"doss04" wrote:

I think i may have missed something. Hopfully someone can help. I have a
worksheet with a list of names starting in col A5 The names have information
in columns B-J. I have a search window in A1. The problem is when i type in
the name, the name shows in the search window that it in the column, but the
name and info doesn't appear. I still have to scroll down to find it. Is
there a way to have that info either show at the top of the list or in the
search window? Thanks