ExcelBanter - formula that once it is true info stays in new cell?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - formula that once it is true info stays in new cell? (https://www.excelbanter.com/excel-programming/407382-formula-once-true-info-stays-new-cell.html)

tdh3691

formula that once it is true info stays in new cell?

looking for a way that when a cell value matches another the formula answer
stays in the new location even when info in firs cell is changed.

All times are GMT +1. The time now is 11:44 AM.