Row lookup

[sanders]

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


Thank

 

[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