Forum Discussion
Formula works in some cells but not others
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...
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.
