Row lookup

[sanders]

Hi,
I am looking for a way to examine each row of a list, and if the first entry in the row is the same as the condition I have set, to return the whole row in a separate sheet.


Thanks

[Bernie Deitrick]

sanders,

With your list on Sheet1, on the other sheet, put your cirteria into cell A1, then use this formula
in cell A2:

=VLOOKUP($A$1,Sheet1!$A$1:$Z$1000,COLUMN(),FALSE)

Copy A2, and paste across for as many columnas as you have on Sheet1. Adjust ranges references as
needed.

HTH,
Bernie
MS Excel MVP


"sanders" <[email protected]> wrote in message
news:[email protected]...
>
> Hi,
> I am looking for a way to examine each row of a list, and if the first
> entry in the row is the same as the condition I have set, to return the
> whole row in a separate sheet.
>
>
> Thanks
>
>
> --
> sanders
> ------------------------------------------------------------------------
> sanders's Profile: http://www.excelforum.com/member.php...o&userid=36745
> View this thread: http://www.excelforum.com/showthread...hreadid=565922
>