Looking up 2 columns and displaying 3rd column on new sheet

mikequick 1 Posts Monday July 31, 2017Registration date July 31, 2017 Last seen - Jul 31, 2017 at 12:11 PM - Latest reply: ac3mark 9964 Posts Monday June 3, 2013Registration dateModeratorStatus July 19, 2018 Last seen
- Jul 31, 2017 at 04:52 PM


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. 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!
See more 

Your reply

1 reply

ac3mark 9964 Posts Monday June 3, 2013Registration dateModeratorStatus July 19, 2018 Last seen - Jul 31, 2017 at 04:52 PM
0
Thank you
The syntax for AND is as follows:
=AND(LogicTest1,LogicTest2)
So, if logictest1 and logictest2 is true, returns true.

Now, you can add in an IF, for:
=IF(AND(A2<A3,A2<100),A2,False)

The above code, will place the value of A2, into what cell is testing for the value, as long as A2 is less than A3, AND A2 is Less than 100.

I hope this helps you out!
Respond to ac3mark