Formula works in some cells but not others

New Contributor

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

 

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

kelly_lieurance_0-1656678296775.png

 

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

@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.

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

@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.

@Hans Vogelaar 

sheet with bad formula 

kelly_lieurance_0-1656685679785.png

sheet the vlookup goes to 

kelly_lieurance_1-1656685738269.png

second half of sheet vlookup goes to

 

@kelly_lieurance 

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