| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a function like Vlookup that works with cell colors?
I have a spreadsheet that has Name, Task, Time....
Because the same person might do multiple tasks, the cells are color coded. So i have....ex. John and his cell is yellow. Among his taks are sweeping, dusting, cleaning windows they are also highlighted in yellow. What i want to do in a formula is to type John's name and for his tasks to be looked up by the color so I can have the following... John Sweeping Dusting Cleaning windows is this possible with any of the formulas in excel? I really need the help because John needs to get going with his taks :) Thank you for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| range label works in VLOOKUP except if refenced in another cell | Excel Worksheet Functions | |||
| Function works in one cell but not another | Excel Worksheet Functions | |||
| referencing active cell works in a sub but not in a custom function | Excel Worksheet Functions | |||
| referencing active cell works in a sub but not in a custom function | Excel Worksheet Functions | |||
| Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
Threaded Mode
