The last formula didn't quite work. What I require is I will have 2 input boxes. The first input box I would put in some text that will match the headers on another sheet. The second input box I would put in some text that will match some of the rows in the column that I first searched. Then the result would be matching rows in another column. It would be easier if I could post an attachment but I can't. Perhaps you know how I can do this.
You can try putting a border around part of your data and then use copy / paste to put in the forum. We just need a small sample and the answer you are looking for.
Will there be more than one answer to return (you stated match some rows)?