Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find, Lookup, Match, can't figure it out.
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? -- Thanks for your help in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find, Lookup, Match, can't figure it out.
Functions in cells can't write to other cells. They can only return values to
the cell that holds the formula/function. fdebelo wrote: 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? -- Thanks for your help in advance. -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find, Lookup, Match, can't figure it out.
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 -- Mikha ------------------------------------------------------------------------ Mikha's Profile: http://www.excelforum.com/member.php...o&userid=30476 View this thread: http://www.excelforum.com/showthread...hreadid=501332 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find, Lookup, Match, can't figure it out.
Thanks for the help
-- Thanks for your help in advance. "Dave Peterson" wrote: Functions in cells can't write to other cells. They can only return values to the cell that holds the formula/function. fdebelo wrote: 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? -- Thanks for your help in advance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find closest match to a reference number in a row of numbers | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Find text in another workbook and paste if found match - VBA | Excel Discussion (Misc queries) | |||
Match function...random search? | Excel Worksheet Functions | |||
Lookup then Match and insert value from next column | Excel Worksheet Functions |