Something like this?
=IF(AND((OFFSET('Full Survey'!D$1,(ROWS(H$3:H3)-1)*27,0)="SINGLE")),(OFFSET('Full Survey'!H$14,(ROWS(H$3:H3)-1)*27,0)="IMPROVE")),1,"")
Something like this?
=IF(AND((OFFSET('Full Survey'!D$1,(ROWS(H$3:H3)-1)*27,0)="SINGLE")),(OFFSET('Full Survey'!H$14,(ROWS(H$3:H3)-1)*27,0)="IMPROVE")),1,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks