INDEX formula that ignores specific values

Alethea Pollack

I want to index a column in my sheet to bring in values from another sheet. In that formula I would like it to ignore specific values (??, NA). Is there a way to incorporate that into my formula so that I only bring in the date values and nothing else?

Joe Goetschel

Maybe add an IF/OR formula in front of the index.

=IF(OR({Source - Run date}="??",{Source - Run date}="NA"),"",INDEX FORMULA HERE)