Forum Discussion
VLOOKUP with parenthesis and single quotes
Hi All,
I am trying to do a vlookup on a table that has parenthesis and single quotes. When I try to lookup data that I know is on the table, I get #N/A . I’ve made the cells in the table text and general and I receive the same results, #N/A. Is there a special way to handle the parenthesis and quotes?
Formula:
=VLOOKUP(B2,TableB!$A$2:$B$11,2,FALSE)
TableA:
Item | Recommendation |
1.1.1 | (L1) Ensure 'Minimum password age' is set to '1 or more day(s)' |
1.1.2 | (L1) Ensure 'Maximum password age' is set to '60 or fewer days. but not 0' |
1.1.3 | (L1) Ensure 'Minimum password age' is set to '1 or more day(s)' |
1.1.4 | (L1) Ensure 'Minimum password length' is set to '14 or more character(s)' |
1.1.5 | (L1) Ensure 'Password must meet complexity requirements' is set to 'Enabled' |
1.1.6 | (L1) Ensure 'Store passwords using reversible encryption' is set to 'Disabled' |
1.2.1 | (L1) Ensure 'Account lockout duration' is set to '15 or more minute(s)' |
1.2.2 | (L1) Ensure 'Account lockout threshold' is set to '10 or fewer invalid logon attempt(s). but not 0' |
1.2.3 | (L1) Ensure 'Reset account lockout counter after' is set to '15 or more minute(s)' |
2.2.1 | (L1) Ensure 'Access Credential Manager as a trusted caller' is set to 'No One' |
TableB:
Section | Recommendation |
1.1.1 | (L1) Ensure 'Enforce password history' is set to '24 or more password(s)' |
1.1.2 | (L1) Ensure 'Maximum password age' is set to '60 or fewer days. but not 0' |
1.1.3 | (L1) Ensure 'Minimum password age' is set to '1 or more day(s)' |
1.1.4 | (L1) Ensure 'Minimum password length' is set to '14 or more character(s)' |
1.1.5 | (L1) Ensure 'Password must meet complexity requirements' is set to 'Enabled' |
1.1.6 | (L1) Ensure 'Store passwords using reversible encryption' is set to 'Disabled' |
1.2.1 | (L1) Ensure 'Account lockout duration' is set to '15 or more minute(s)' |
1.2.2 | (L1) Ensure 'Account lockout threshold' is set to '10 or fewer invalid logon attempt(s). but not 0' |
1.2.3 | (L1) Ensure 'Reset account lockout counter after' is set to '15 or more minute(s)' |
2.2.1 | (L1) Ensure 'Access Credential Manager as a trusted caller' is set to 'No One' |
1 Reply
- Sorry I am new to the Community space. This should have been posted in Excel's Community. If an Admin can delete this post, it would be most appreciated.
