matching rows

Hi i need to fetch all rows matching a selected value . i cannot use row() , rows () in my application. Kindly help me with an excel formula.
i am reposting this as i need the solution immediately. Kindly help

Thanks & Regards,
Shruthi