I am looking for a quick way to enter a function into an existing function the will make a blank cell whenever #N/A in in the cell. I don't mind if when #N/A is entered in the cell, the text color changes to white so that it blends into the background. Anyone have any ideas. Thanks. the existing function I need this entered into is
=INDEX(Solicitation!$C$10:$J$69,MATCH(1,Solicitation!$P$10:$P$69,0),1)
Bookmarks