Find, Lookup, Match, can't figure it out.

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
Functions in cells can't write to other cells. They can only return values to
the cell that holds the formula/function.
 
As far as I know, Excel formulas cannot look up for "Colour of cells".
My suggestion - to select all "Blue" cells by Edit - Find - Options -
Format and put in neighbour cells e.g. "1", for yellow cells - "2"
etc.
After this you will be able to use VLOOKUP function.

br/ Mikha
 
Back
Top