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
|