|Without seeing your data and formula, we can't offer too much more than phil22 has offered.|
As noted at that website, #N/A can often be the result of data that you think matches but in reality doesn't.
One quick way to check is to visually find what you think is a match and use a simple formula to see if they really do match.
e.g. With your lookup value in A1 and your "visual match" in C11, enter this formula in any cell:
If the formula returns TRUE, then it is an exact match and you should look at your VLOOKUP formula. If the formula returns FALSE, then it is not an exact match.
There could be a space, a hidden character, etc.
As I said, without more information we can't offer anything more specific.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.