Display Excell cell that contains text

Lets say i have exel with columns:

John 1234,Jerry 8329, Michael 2312
Jerry 5543,John 6423, Michael 4324
Michael 1122,Jerry 5345, John 3354

I'm looking for a Excell formula that woud search through those 3 columns for cell containing word "John" and display cells full content.

End result shoud look like :

John 1234,Jerry 8329, Michael 2312 = John 1234
Jerry 5543,John 6423, Michael 4324 = John 6423
Michael 1122,Jerry 5345, John 3354 = John 3354

So far i only managed to find formula that says in what column searched word is found :

=MATCH("*John*";A1:C1;0) 

Perhaps it will help somehow.

Answers


Yes, good start,

Try this in D1 and drag it down

=INDEX(A1:C1,MATCH("*John*",A1:C1,0))


Need Your Help

Date based get that monthly report in php

php mysql date group-by between

Given Date is 2015-08-10 but i need to get the August month report.Do not use(BETWEEN 2015-08-01 and 2015-08-31).Please advise me.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.