Dec 05 2022 03:24 AM
Good day
I'm trying to set up sheet B were if the word "lost" is inserted in column F from sheet A then the values for column A in sheet A for that row is duplicated in sheet B column A, if the value for column F in sheet A is blank then no values are transferred. Can someone please assist with the formula for this?
Thank you very much
Dec 05 2022 03:34 AM
FILTER can do this. Attached is a sample workbook with FILTER formulas.
Dec 05 2022 04:28 AM
=IF(ISNUMBER(SEARCH("lost",'Sheet A'!F1)),'Sheet A'!A1,"")
An alternative could be this formula in cell A1 in Sheet B.
Sheet A
Sheet B