Search code examples
google-sheetsgoogle-sheets-formulagoogle-sheets-querygs-vlookupimportrange

iferror doesn't return value/error message

So I have this function:

=IFERROR(VLOOKUP(C825,IMPORTRANGE("gigduiagduaigiyug938y212hiugs","ApprovedVideos!A:G"),4,false),"Nil")

It doesn't work the way I want it to: If the cell is empty, returns 'Nil' and if it's not empty, just display the value that the importrange/vlookup returns.

What's wrong??

Solution

  • try:

    =ARRAYFORMULA(IF(C2:C="",,IFNA(VLOOKUP(C2:C, 
 IMPORTRANGE("1oONnCRazwAwr3k2K0gc-tAT1SDLcBi2PnWAisXSzhtE",
 "VideoReport!A:G"), {5,6}, 0), 
 "No Info Found")))

    0