Hi Guys,
I am really struggling to get my formula to work and am hoping someone can lend me a hand.
I've attached the file to give a better idea of what I'm trying to achieve but please find the background below:
What I'm trying to do is to see if a DUO GCID exists in the same GUO GCID as in the Current GUO GCID List. To do this I need to lookup the DUO GCID in the GCID list to get it's GUO GCID.
So for example:
[B]
GCID |
GUO GCID |
DUO GCID |
RESULT |
1 |
1 |
1 |
Exists - as in GCID List and Criteria GUO GCID List |
2 |
1 |
1 |
Exists - as in GCID List and Criteria GUO GCID List |
3 |
5 |
3 |
Exists - as in GCID List and Criteria GUO GCID List |
4 |
2 |
4 |
Not Exists - as not in Criteria GUO GCID list though in GCID List |
Criteria GUO GCID: 1, 5
I tried using the below formula but due to the blanks in my criteria list it's calculating them and returning a TRUE result.
I'm not honestly sure if SUMPRODUCT is the best route so all recommendations welcome. Please let me know if any questions and I'll try answer them best I can.
Bookmarks