Formula works in some cells but not others

New Contributor

The below formula works in some cells and returns #N/A in others. 





when I do the trace it shows refrecing to the other sheet in the book but I can't see where it's 


5 Replies


Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.

my company dose not allow that, would more screen shots be of any help?


Perhaps a new screenshot, with ALL relevant columns included, and also a screenshot of the other sheet, with all relevant columns. You can blank out or change data that you'd rather not show.

@Hans Vogelaar 

sheet with bad formula 


sheet the vlookup goes to 


second half of sheet vlookup goes to



I'm really sorry, but I can't do anything with that...