Capture.PNG
I am trying to figure out how to display the color onto a second worksheet. If column a=1 AND column b=1, then I want the value of C2 displayed on a second worksheet (in cell A1). It will not always be BLUE. I just need whatever is in cell C2 at the time to be displayed when the criteria is met. The PRESS and PRIORITY combinations will never be duplicated. Any help would be greatly appreciated!
Last edited by mikequick23; 07-31-2017 at 12:33 PM.
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Formula:
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Looks like that did the trick. Thanks for the saved time!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks