New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

search and auto fill

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

search and auto fill

Postby Sellappan » Wed Jul 06, 2016 1:43 am

how to find and fill adjacent cells with formulas in excel

EXAMBLE--IF I want to find all the cells with the word "shop" and auto fill the word "keeper" from its second right cell.(like SHOP_ _ KEEPER)
  • 0

Sellappan
Rookie
 
Posts: 1
Joined: Jul 6, 2016
Reputation: 0
Excel Version: 2010

Re: search and auto fill

Postby Kevin UK » Wed Jul 06, 2016 11:46 pm

Without a example file. Assuming that your data is in A1:A10, in Bi & copy down.

Code: Select all
=IF(ISNUMBER(SEARCH("Shop",A1)),"SHOP__KEEPER","")
  • 0

Regards

Kevin
Kevin UK
Excel Master
 
Posts: 568
Joined: Jun 24, 2012
Reputation: 86
Excel Version: 2016


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 33 guests