Question

if cell contain another cell value replace it with its refficient

Answer 1

Supposing you have a range of cells, if cell A1 contains a certain text such as “Yes”, you need another cell C1 to return a specific value “approve”. And if cell A1 contains other text, cell C1 returns nothing. This article shows you method to achieve it.

Return value in another cell if a cell contains certain text with formula

Easily Select Entire Rows Based On Cell Value In A Certian Column:

The Select Specific Cells utility of Kutools for Excel can help you quickly select entire rows based on cell value in a certian column in Excel as below screenshot shown. After selecting all rows based on cell value, you can manually move or copy them to a new location as you need in Excel.