Formula works in some cells but not others

[kelly_lieurance]

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

=IF(F2>0,VLOOKUP($A2&F2,DrayConsolidation!$A:$E,5,FALSE),"")

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

[#2]

@kelly_lieurance 

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.

[#3]

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

[#4]

@kelly_lieurance 

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.

[#5]

@Hans Vogelaar 

sheet with bad formula 

sheet the vlookup goes to 

second half of sheet vlookup goes to

[#6]

@kelly_lieurance 

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