=VLOOKUP($J$2,maint!$I2:$EJ18,MATCH(table17[[#Headers],[notes2]],table17[[#Headers],[To: owner/rep]:[notes13]],0),0)
If the cell it references on this other sheet doesn't happen to have anything in it, it displays zero. I'd rather it display something else that I tell it to in the event the cell is empty. I was thinking 'if(reference formula, returns nothing, then "- - -", otherwise reference formula)' which is repetitive thus long/inefficient for my taste. Was hoping there was an easier way to do this. Thanks