Forum Discussion

kelly_lieurance's avatar
kelly_lieurance
Copper Contributor
Jul 01, 2022

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 in the book but I can't see where it's 

 

Formulas and Functions

5 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jul 01, 2022

    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.

    • kelly_lieurance's avatar
      kelly_lieurance
      Copper Contributor
      Jul 01, 2022
      my company dose not allow that, would more screen shots be of any help?
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Jul 01, 2022

        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.

Resources