Double search formula

Nigeljones

New Member
Joined
Apr 26, 2013
Messages
26
Office Version
  1. 365
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,719
Office Version
  1. 365
Platform
  1. Windows
It would help if you would post a small sample, but maybe something like this?
Excel Workbook
ABCDEFG
1NameTest1Test2Test3SearchTest2
2N1some1What2Why7What6
3N2some2What3Why8
4N3some3What4Why9NameN5
5N4some4What5Why10
6N5some5What6Why11
7N6some6What7Why12
8N7some7What8Why13
Sheet
 

Nigeljones

New Member
Joined
Apr 26, 2013
Messages
26
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Apr 26, 2013
Messages
26
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
Oct 10, 2011
Messages
4,719
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Apr 26, 2013
Messages
26
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,569
Messages
5,596,915
Members
414,110
Latest member
docops

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top