Forum Discussion

sbishop785's avatar
sbishop785
Copper Contributor
Apr 03, 2024
Solved

RE: Help with rewriting expression to exclude #N/A

Hi there Microsoft Community!!!   I'm a bit of a noob to excel, but I'm trying to create something for our org. The excel sheet below grabs values from a separate sheet using this expression:  ...
  • Harun24HR's avatar
    Apr 03, 2024

    sbishop785 Use IFERROR() function like-

    =IFERROR(VLOOKUP(H5,'Video Overview'!B:D,2,0),"")

     

Resources