IsBlank

[j4ymf]

hello

I have this formula
=INDEX(Holidays!$A$4:$OE$92,MATCH(O66,Holidays!$A$4:$A$92,0),MATCH($Q$54,Holidays!$A$3:$OE$3,0))

I need to include if O66 is blank, how would I do that

than you Jason

 

[Rick Rothstein]

I have this formula
=INDEX(Holidays!$A$4:$OE$92,MATCH(O66,Holidays!$A$4:$A$92,0),MATCH($Q$54,Holidays!$A$3:$OE$3,0))

I need to include if O66 is blank, how would I do that

Your question is not entirely clear (include it how?) but perhaps this is what you meant...

=IF(O66="","",INDEX(Holidays!$A$4:$OE$92,MATCH(O66,Holidays!$A$4:$A$92,0),MATCH($Q$54,Holidays!$A$3:$OE$3,0)))

 

[j4ymf]

Thank you rick