try
Formula:
=IF(OR(INDEX(INDIRECT(Tab!$C$8&"!"&Tab!$C$8&"Table23"),3,2)="Y",INDEX(INDIRECT(Tab!$C$8&"!"&Tab!$C$8&"Table23"),3,2)="Yes"),"Yes","Not Yes")
the syntax for or is
=OR(condition1,condition2,conditionx,...,conditiony)
try
Formula:
=IF(OR(INDEX(INDIRECT(Tab!$C$8&"!"&Tab!$C$8&"Table23"),3,2)="Y",INDEX(INDIRECT(Tab!$C$8&"!"&Tab!$C$8&"Table23"),3,2)="Yes"),"Yes","Not Yes")
the syntax for or is
=OR(condition1,condition2,conditionx,...,conditiony)
Like a post? Click the star below it!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks