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 intended so it’s technically correct, however, I want this formula to work when rows are also blank. This sheet is used to help us calculate employee tips and pay. 

Please see image of the summary sheet. The rows calculate the information from the daily sheets. The daily sheets reference the Jobs table.

On the daily sheet, column C references the Jobs table on the summary sheet. Column O references column C to calculate what happens to columns P – U. The formula for column O is: 

=IF(ISBLANK(C5),””,INDEX(JOB_DATA,MATCH(C5,JOB_NAME,0),4))

JOB_DATA is the entire row in the Jobs table. JOB_NAME is the Position column.

The blank rows on the summary and daily sheets are there for us to add/remove employees. Is there a way for these #N/A cells to show as a blank? 

​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 intended so it’s technically correct, however, I want this formula to work when rows are also blank. This sheet is used to help us calculate employee tips and pay. Please see image of the summary sheet. The rows calculate the information from the daily sheets. The daily sheets reference the Jobs table. On the daily sheet, column C references the Jobs table on the summary sheet. Column O references column C to calculate what happens to columns P – U. The formula for column O is: =IF(ISBLANK(C5),””,INDEX(JOB_DATA,MATCH(C5,JOB_NAME,0),4)) JOB_DATA is the entire row in the Jobs table. JOB_NAME is the Position column. The blank rows on the summary and daily sheets are there for us to add/remove employees. Is there a way for these #N/A cells to show as a blank?     Read More

​