Excel If > Then formula to match columns and provide result...
All,
I am in the middle of a project of comparing VPN users (via AD Group SSLVPNUsers) with users in a certain company group. Essentially, management wants to know who, if any in this group have VPN access. Now, I have done this a million times in the past for various managers and groups but I seem to have screwed up my templated formula.
I am not the greatest at Excel, quite frankly I hate it. I would however like some help with this formula. Scenario below:
Column A (starts at A2) = List of users in this specific group (441 users)
Column B (starts at B2) = List of ALL users in the AD Group SSLVPNUsers (43,596 users)
I want a formula that looks at Column A to see if its in Column B, if so then its True (in column C). If not, then its false (in column C).
I tried explaining it the best I can. Hopefully you understand. My current formula is below:
=IF(ISNA(MATCH(A2:A441-B2:B43596,Search,0)),FALSE,TRUE)