Dynamic Named Range with INDEX that handles blanks and errors?

[blbat]

With the outstanding help of jonmo1, I created the following Dynamic named ranges:

Name: LastRow
Scope: Workbook
Refers to: =MATCH(2,1/(Combined!$A:$A<>""))

Name: ColO
Scope: Workbook
Refers to: =Combined!$O$2:INDEX(Combined!$O:$O,Combined!LastRow)

Name: ColP
Scope: Workbook
Refers to: =Combined!$P$2:INDEX(Combined!$P:$P,Combined!LastRow)

Name: ColS
Scope: Workbook
Refers to: =Combined!$S$2:INDEX(Combined!$S:$S,Combined!LastRow)

On the sheet named "Combined", Column "A" will NEVER have blank cells, or errors, within the contiguous range of used cells.

However, Columns O,P, and S can have Blanks or Errors.

My question is- is there a way to write within the "refers to:" formula to handle these blanks and errors using ISERROR and ISBLANK?

 

[T. Valko]

That's an excellent example T.Valko-

It will make it easier for me to explain to a couple other folks in my office.

I included a column showing the Column "C" values that meet BOTH the criteria sets and a column that shows the values that meet Only the "X" criteria for Column "B" so I can easily show the difference.

I appreciate your time, and everyone else's too!

You're welcome. Thanks for the feedback!