G
Guest
If Sheet1 A1 is "Blue". Sheet2 ColumnA is "Red, Green, Yellow". Can function
look in Sheet2 ColumnA for "Blue", if not found, find the first empty cell
and paste "Blue" in that Cell. If Blue exists, then overwrite. Is this
possible?
look in Sheet2 ColumnA for "Blue", if not found, find the first empty cell
and paste "Blue" in that Cell. If Blue exists, then overwrite. Is this
possible?