Find Text String in Range of Cells

**super21** · 07-01-2012, 10:52 PM

Hi there,
Trying to write an excel formula to find plans based on text string descriptions. Basically looks like the attached spreadsheet. Below is a simple example:
A1: Plan 1
B1: Airplanes
C1: Tires

Look in spreadsheet for better example, note it illistrates what I want it to do manually without any programming behind it.

Now this is what I want if statement to do, obviously it won't look exactly like this =if(B1:C1="Airplanes, return plan name, if false keep searching) end function after range limit is reacher, Range 1-100.

This make sense? Is there a way to do this with functions? Or is this a VBA program thing? Not used VBA before so any code would be appreciated.

sample sheet.xlsx

**Ron Coderre** · 07-02-2012, 09:43 AM

Using your posted workbook, this regular formula returns the values you're looking for:
On the Plan Data sheet

Please Login or Register  to view this content.

Copy that formula across and down as far as you need.

Is that something you can work with?

**super21** · 08-03-2012, 01:56 AM

sample sheet.xlsx

I have updated my mock up sheet. I need a little help. I want to transpose results from horzonital display of plans to vertical display of plans. Also, I wanted to add one adtional search criteria capability, organization. Essentially this will narrow down results if you specify an organization. If you don't it should still display all results. The excel attached has a mock up of what I want formula to do. Can anyone help design the plan finding formula?

Thanks for all your help out there.