I can't use "FALSE" as the source document and formula location are formatted slightly different. I'm dealing with account names. So for instance source document contains Deloitte with a number at the end. The formulated area also contains Deloitte but without the numbers on the end of it. This makes using "FALSE" seemingly impossible and I get N/A as it obviously cannot find a direct match. Using TRUE works in most situations but it seems if there is another account name that shares 2 letters it will always "see" and return results for that one first. Example: my results for Bloomberg are really that of Blackrock (just above it in alphabetical order) and for Deloitte I'm getting Dechart, so again, the same issue. Is there a way to make the VLOOKUP slightly more specific, without requesting an exact match "FALSE"?
Many, many thanks in advance.
Jeremy
Bookmarks