Vlookup not working if data has ( or )

[adrian.rolla]

Vlookup not working if data has ( or )

having the following data on A1, A2, and A3:

one

two

three(bug)

and using vlookup(“three(bug)”,A1:A3,1,0) will return #N/A instead of returning “three(bug)”.


How can this bug be fixed?

[mariosv]

Countif does not count cells that have . ( ) and other non aphabetic characters

Countif does not count cells that have . ( ) and other non aphabetic characters. Lets use an example having the following data in colum A: hello hi. hi. how are you (hi) how are you (hi) how are you (hi) and having the formula =countif(A:A,Ax) in each row of column B, where x is the row number, will calculate rows like this: hello 1 hi. 0 hi. 0 how are you (hi) 0 how are you (hi) 0 how are you (hi) 0 instead of what should be: hello 1 hi. 2 hi. 2 how are yo…