How To Lookup a full row if it contain a text in a spec coloumn from diffrent sheet?
 

I have a Database consists of

11 Coloumn
500 Row
in a Sheet called Data Base

want a formula that can look a row from Data Base if it contains a specific text from a specific column

example :

need to search from Data Base column E for the word : Project1 , if found : to look up the whole row of 11 columns to sheet 2

How To Lookup a full row if it contain a text in a spec coloumn from diffrent sheet?
 

On Wed, 2 Oct 2013 11:50:40 +0100, Khaled Awad wrote:

need to search from Data Base column E for the word : Project1 , if
found : to look up the whole row of 11 columns to sheet 2

Not sure what you mean by "lookup the whole row of 11 columns to sheet 2"

If what you mean is that you want to return the values of the 11 columns in that row to 11 columns on sheet2, then

Sheet2!A1: =INDEX('Data Base'!$A$1:$K$500,MATCH("Project1",'Data Base'!$E$1:$E$500,0),COLUMNS($A:A))

Then fill right to K1 (11th column).

You can put that initial formula in any cell (without changing anything else), and fill right for 11 columns and still get the same result.
"Project1" could also be a cell reference containing Project1 (or some other value)