I am so frustrated and hoping someone can help me quickly as I have to complete this by tomorrow.
I have a spreadsheet with 3 tabs: Users, Groups and XWalk
Users contains a name and a facility that person is associated with.
Groups contains a name and the groups the person is currently associated with.
The Xwalk shows a mapping of facility to group names.
The goal is to identify is a user is in all the applicable groups for the facilities they belong in. For example, KEY_NAME: Cnocjv, Vyumldt is in 4 facilities but only 1 group. I need a table that shows whether a user is "Already in group" or "Need to Add".
For the life of me I can not get this to work. Someone, please help me.
I was hoping it would be as simple as something like if(Facility=Current_CAG,'Already in Group','Need to Add')
