Forum Discussion

accounting1005's avatar
accounting1005
Copper Contributor
Sep 27, 2024

Need help with #N/A display for IF Function

Hello Experts,   I'm reworking a sheet that I did not create and need help with replacing the #N/A display with a blank when the referencing cell is blank. Is this possible? The formula works as in...
  • m_tarler's avatar
    m_tarler
    Sep 27, 2024

    accounting1005 I apologize I missed that "4" in the column for the index.  you just need to add INDEX or CHOOSECOLS so the following works:

    =XLOOKUP(C5,JOB_NAME,CHOOSECOLS(JOB_DATA,4),"")

    Or better yet I named your Jobs table (Table Design tab) JOBS so now you can just call out the column of interest (actually you could before but it was named like Table5 so it didn't mean a lot to the reader. But now:

    =XLOOKUP(C5,JOB_NAME,JOBS[Tip Share],"")

     so you can clearly see you are returning "Tip Share" value out of the JOBS table.

    See attached I updated Monday

Resources