Row lookup
 

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

Row lookup
 

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" wrote in message
...

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