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...
Formulas and Functions
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.

  • kelly_lieurance's avatar
    kelly_lieurance
    Copper Contributor
    Jul 01, 2022

    HansVogelaar 

    sheet with bad formula 

    sheet the vlookup goes to 

    second half of sheet vlookup goes to

     

Resources