Problem with vlookup

[AnderE]

I am having a problem with my vlookup. I know the formula is correct, but it keeps returning #N/A. Is there a possibility I have disable something that is stopping the calculation from working?

My formula is below:

=VLOOKUP(A22,'[Feature code model lookup.xls]Feature Code'!$A:$D,4,FALSE)

 

[njimack]

Does the value in A22 actually exist in column A of the file you're looking in?

 

[AnderE]

yes it definitely does, I have searched using ctrl F and copy paste..

I have tried trimming spaces but still it isn't working...

going mad!

 

[Pauljj]

When you trimmed spaces, did you trim both A22 as well as column A of the section you are looking up ?

 

[njimack]

Using TRIM will remove spaces but not non-printing characters. Maybe try testing the length of the cell using =LEN(A22), or comparing it to the cell in your lookup range, using =EXACT(A22,[Feature code model lookup.xls]Feature Code'!A22)

 

[AnderE]

I have fixed it! I went to Tools - Options and reset the calculation tab to Automatic. For some reason it had changed to manual.

Phew! Back to work now

Thanks!