VLOOKUP with parenthesis and single quotes

%3CLINGO-SUB%20id%3D%22lingo-sub-264698%22%20slang%3D%22en-US%22%3EVLOOKUP%20with%20parenthesis%20and%20single%20quotes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-264698%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20do%20a%20vlookup%20on%20a%20table%20that%20has%20parenthesis%20and%20single%20quotes.%20When%20I%20try%20to%20lookup%20data%20that%20I%20know%20is%20on%20the%20table%2C%20I%20get%20%23N%2FA%20.%20I%E2%80%99ve%20made%20the%20cells%20in%20the%20table%20text%20and%20general%20and%20I%20receive%20the%20same%20results%2C%20%23N%2FA.%20Is%20there%20a%20special%20way%20to%20handle%20the%20parenthesis%20and%20quotes%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EFormula%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3DVLOOKUP(B2%2CTableB!%24A%242%3A%24B%2411%2C2%2CFALSE)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ETableA%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CP%3EItem%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3ERecommendation%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E1.1.1%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E(L1)%20Ensure%20'Minimum%20password%20age'%20is%20set%20to%20'1%20or%20more%20day(s)'%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E1.1.2%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E(L1)%26nbsp%3B%20Ensure%20'Maximum%20password%20age'%20is%20set%20to%20'60%20or%20fewer%20days.%20but%20not%200'%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E1.1.3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E(L1)%20Ensure%20'Minimum%20password%20age'%20is%20set%20to%20'1%20or%20more%20day(s)'%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E1.1.4%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E(L1)%20Ensure%20'Minimum%20password%20length'%20is%20set%20to%20'14%20or%20more%20character(s)'%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E1.1.5%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E(L1)%20Ensure%20'Password%20must%20meet%20complexity%20requirements'%20is%20set%20to%20'Enabled'%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E1.1.6%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E(L1)%20Ensure%20'Store%20passwords%20using%20reversible%20encryption'%20is%20set%20to%20'Disabled'%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E1.2.1%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E(L1)%20Ensure%20'Account%20lockout%20duration'%20is%20set%20to%20'15%20or%20more%20minute(s)'%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E1.2.2%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E(L1)%20Ensure%20'Account%20lockout%20threshold'%20is%20set%20to%20'10%20or%20fewer%20invalid%20logon%20attempt(s).%20but%20not%200'%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E1.2.3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E(L1)%20Ensure%20'Reset%20account%20lockout%20counter%20after'%20is%20set%20to%20'15%20or%20more%20minute(s)'%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E2.2.1%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E(L1)%20Ensure%20'Access%20Credential%20Manager%20as%20a%20trusted%20caller'%20is%20set%20to%20'No%20One'%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ETableB%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CP%3ESection%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3ERecommendation%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E1.1.1%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E(L1)%20Ensure%20'Enforce%20password%20history'%20is%20set%20to%20'24%20or%20more%20password(s)'%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E1.1.2%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E(L1)%20Ensure%20'Maximum%20password%20age'%20is%20set%20to%20'60%20or%20fewer%20days.%20but%20not%200'%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E1.1.3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E(L1)%20Ensure%20'Minimum%20password%20age'%20is%20set%20to%20'1%20or%20more%20day(s)'%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E1.1.4%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E(L1)%20Ensure%20'Minimum%20password%20length'%20is%20set%20to%20'14%20or%20more%20character(s)'%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E1.1.5%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E(L1)%20Ensure%20'Password%20must%20meet%20complexity%20requirements'%20is%20set%20to%20'Enabled'%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E1.1.6%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E(L1)%20Ensure%20'Store%20passwords%20using%20reversible%20encryption'%20is%20set%20to%20'Disabled'%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E1.2.1%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E(L1)%20Ensure%20'Account%20lockout%20duration'%20is%20set%20to%20'15%20or%20more%20minute(s)'%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E1.2.2%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E(L1)%20Ensure%20'Account%20lockout%20threshold'%20is%20set%20to%20'10%20or%20fewer%20invalid%20logon%20attempt(s).%20but%20not%200'%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E1.2.3%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E(L1)%20Ensure%20'Reset%20account%20lockout%20counter%20after'%20is%20set%20to%20'15%20or%20more%20minute(s)'%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E2.2.1%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E(L1)%20Ensure%20'Access%20Credential%20Manager%20as%20a%20trusted%20caller'%20is%20set%20to%20'No%20One'%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-264698%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-264705%22%20slang%3D%22en-US%22%3ERE%3A%20VLOOKUP%20with%20parenthesis%20and%20single%20quotes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-264705%22%20slang%3D%22en-US%22%3ESorry%20I%20am%20new%20to%20the%20Community%20space.%20This%20should%20have%20been%20posted%20in%20Excel's%20Community.%20If%20an%20Admin%20can%20delete%20this%20post%2C%20it%20would%20be%20most%20appreciated.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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
Highlighted
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.