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)