Double search formula

[Nigeljones]

I need a formula that will search the column headers for a user inputted text and then search that column for another user inputted text then it will give the result as name in another column

 

[AhoyNC]

It would help if you would post a small sample, but maybe something like this?

Excel Workbook
	A	B	C	D	E	F	G
1	Name	Test1	Test2	Test3		Search	Test2
2	N1	some1	What2	Why7			What6
3	N2	some2	What3	Why8
4	N3	some3	What4	Why9		Name	N5
5	N4	some4	What5	Why10
6	N5	some5	What6	Why11
7	N6	some6	What7	Why12
8	N7	some7	What8	Why13
Sheet

 

[Nigeljones]

I will try the formula you posted and adapt it to my spreadsheet. If it doesn't work I will have to post the actual spreadsheet as it can be quite confusing. Thanks for your quick reply

 

[Nigeljones]

Hi
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.

 

[AhoyNC]

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)?

 

[Nigeljones]

I am just trying a formula I got elsewhere that I think might work. I just have to adapt it to my spreadsheet. I will let you know. Thanks for all your help.