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")))
- How to set column to plain text format for every sheet?
- Exceeded maximum execution time when trying to create a matrix
- getLastRow but ignore column A and Logger assistance
- Google Sheets Query referencing a Dropdown selection
- Check if edited cell is in a specific range
- Simpler check if a cell was edited and a certain value inserted
- How to sum / aggregate the results of "Filter" function
- onEdit combine timestamp and username/email address not working
- Copy value from a cell to the rest of a colum
- How to count the number of rows that meet a boolean condition?
- Google Sheets - Difference of Two Columns With Duplicate Values
- Using Apps Script to automate sending multiple emails from a google sheet, each with a different specific pdf attachment stored in Google Drive
- How to enumerate categories with formula in Google Sheets
- Sorting Names from rows of one sheet to another
- Uncheck checkboxes in an array
- How to do Cumulative sum in Google Sheets with arrayformula()?
- Using Sheets.Spreadsheets.Values.update() Correctly
- How can I automatically set the current date and time when the checkbox is activated?
- Using arrayformula to add suffix, but would like to skip empty cells
- Coloring the searched word in Google Sheets
- copyTo using {contentsOnly:true} not working
- Email from script Sending as [object Object]
- Display averages of a column for past five months in Google Sheets
- Sending data from HTML form to Google Sheets
- Initiate a download
- Is this possible - Python script to fill a Google spreadsheet?
- Is there any way to automatically create installable triggers?
- Return Top value plus ties for each change in another Column value
- split() in google sheets changes to numeric
- Adding a condition to a MAP formula