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)
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
=IF(ISNUMBER(SEARCH("Shop",A1)),"SHOP__KEEPER","")
Return to General Excel Questions
Users browsing this forum: No registered users and 114 guests